JOB NAME: TESQ

JOB TITLE: BRS DETAIL STATE AGING REPORTS

DESCRIPTION:
This job is identical to job TESP except that it creates a detail version of Report 5, and no other reports or files.

INPUT:
Frozen file from TEEF (SIS.BR.TRANSFL.F&GEN)

CONTROL PARAMETERS:
    Title:   Selection Record for UCBCE Account Numbers
               Note: In order to produce a report for UCB Continuing Education that is separate from the UCB main campus, a file of continuing education account numbers is needed.  Account numbers that are contained in the selection file will be considered UCB continuing education information and will print on their report.   It is important to note that this information is actually Easytrieve coding that is inserted into the program that produces the report, so the literal values (single quotes and plus sign) are especially important.

    Example:
 
              '10 10132 10979            012901' +
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 
POSITION FIELD VALUE
 1   14  LITERAL Space or comma (,)
15  15  SINGLE QUOTE Literal value - single quote (')
16  17  FUND Chartfield fund for the continuing education account number.
18  18  DELIMITER Space or comma (,)
19  23  ORGANIZATION Chartfield organization ID for the continuing education account number.
24  24  DELIMITER Space or comma (,)
25  29  PROGRAM Chartfield program ID for the continuing education account number. 
30  30  DELIMITER Space or comma (,)
31  40  PROJECT Chartfield project ID for the continuing education account number.
41  41  DELIMITER Space or comma (,)
42  47  ACCOUNT CODE Chartfield account code for the continuing education account number.
48  48  SINGLE QUOTE Literal value - single quote (')
49 49  DELIMITER Space or comma (,)
50 50  PLUS Literal plus sign (+)
Plus signs occur in this position for all account numbers EXCEPT of the last account number.  The last account number should have a space in this field.

    Title:   State Aging Reports control record

      Example:
 
AGING DATE = 20021130 CAMPUS SELECT=1,2,3,4
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 
POSITION FIELD VALUE
 1   13  FIELD LABEL 'AGING DATE = '
14  21  AGING DATE Date to be used to calculate the age of the receivable
Format - CCYYMMDD
22  22  DELIMITER Space or comma (,)
23  36  FIELD LABEL 'CAMPUS SELECT='
37  37  CAMPUS1 First campus to be selected for the report.
Valid= 1,2,3,4, or space
38  38  DELIMITER Space or comma (,)
39  39  CAMPUS2 Second campus to be selected for the report.
Valid= 1,2,3,4, or space
40  40  DELIMITER Space or comma (,)
41  41  CAMPUS3 Third campus to be selected for the report.
Valid= 1,2,3,4, or space
42  42  DELIMITER Space or comma (,)
43  43  CAMPUS4 Fourth campus to be selected for the report.
Valid= 1,2,3,4, or space

Title:    State Aging Report Category  control record
            Note:    A maximum of 12 categories may be specified.

    Example:
 
RANGE DATA = A 0000 0000     CURRENT
RANGE DATA = B 0001 0030    1 -  30 DAYS
RANGE DATA = C 0031 0090   31 -  90 DAYS
RANGE DATA = D 0091 0120   91 - 120 DAYS
RANGE DATA = E 0121 0365   121 - 365 DAYS
RANGE DATA = F 0366 9999   OVER 1 YEAR
12345678901234567890123456789012345678901234567890123456789012345678901234567890

     Format:
 
POSITION FIELD VALUE
 1   13  FIELD LABEL 'RANGE DATA ='
14  14  CATEGORY Identifier for aging category.
15  15  DELIMITER Space or comma (,)
16  19  LOW DAYS Beginning number of days to include in aging range.  Must be numeric.
20  20  DELIMITER Space or comma(,)
21  24  HIGH DAYS Ending number of days to include in aging range.  Must be numeric.
25  25  DELIMITER Space or comma(,)
26  40  DESCRIPTION Description of aging category to be printed on the reports.

REPORT INFO:
TESQx-5D     Detail Aging by FOPPS report
 

OTHER OUTPUT:
Campus download files containing aging reports
    (SIS.DOWNLD.BDB1.TESQ,
    SIS.DOWNLD.BDB2.TESQ,
     SIS.DOWNLD.CSC1.TESQ,
     SIS.DOWNLD.DND1.TESQ,
     SIS.DOWNLD.HSH1.TESQ)