Field Edits for FCPDST (Distribution) file
In Focus Field Name Order
Data Element FOCUS Field name |
Field reference no. | Valid Values |
Account Number ACCTNO |
C0001 | Must be alphanumeric |
Distribution Rate Code CDISTRT |
C890 | A, H |
Description of Service Code-CPS CDOS |
C0078 | See data dictionary |
UC Location code 2 - Universitywide Indicator CLOC2 |
C127 | 1, 2 |
UC Location code 3 - Organizational Category CLOC3 |
C128 | 1, 2 |
Rate Adjustment Indicator CRATEADJ |
C916 | blank, A |
Subaccount Code CSUBACCT |
C105 | Must be numeric |
Derived Percent DERPCT |
C0343 | Must be numeric |
Distribution Pay Rate DSTPAYRT |
C918 | Must be numeric |
Financial Aid Type Code FINAID |
C0899 | blank, X, Y, P, D, S, W |
Time Distribution - Actual MONFTE |
C974 | Must be numeric |
Gross Earnings - Pay Period MONGRS |
C930 | Must be numeric |
Hours Paid - Pay Period MONHRS |
C931 | Must be numeric |
Payment Category Code PAYCAT |
B2237 | blank, A, D, L, N, P, S |
Description of Service Code - PPS PDOS |
0898 | Code must not be blank |
Systemwide Administrative Unit Code SAU |
C4319 | blank, 4, 5, 6, 7, 8, 9 |
Type of Hours Code TYPEHOURS |
B2238 | blank, N, O, P, R |
UCRS Gross Indicator UCRSGROSIND |
B2239 | +1, -1, 0 |