Employee Cost Distribution Segment

 
SEGMENT NAME - COST DISTRIBUTION (DST) – DISPLAYS WITH MVA's ONLY ​ ​ ​
FIELD NAMECOLUMN BEGIN

DATA TYPE

(A/Alpha, N/Numeric)

FIELD LENGTH

DESCRIPTION
COMPANY_KEY1A/N - 03Agency Number (910 Directory)
PAY_GROUP_KEY4A/N - 02

Pay Group 01 – Biweekly (PGR Directory)

Pay Group 06 - University

Pay Group 20 - Judicial Monthly

PAY_LOCATION_KEY6A/N - 04Pay Location (ORG Directory) - 2 to 4 digit alpha/numeric code that identifies the employee's work area/location within an agency. Field is blank if Pay Location not used.
LAST_NAME10A/N - 22Employee Last Name, includes appendage.
FIRST_NAME32A/N - 14Employee First Name
MIDDLE_NAME46A/N - 14Employee Middle Name
SSN_NO60A/N - 09Social Security Number
KEY_DATE69A/N - 08

MVA effective date (CCYYMMDD)

Note:  Date displays only on EAR, FED, STA, DED, DST and NET segments.  Field is 0 filled on BAS, MAD, PAY and POS segments.

PAY_TYPE77A/N - 01

Identifies the type of payroll activity

       M – Manual

       V – Void

       A – Adjustment

       Blank – Regular Pay

 

Note:  The Field is always blank on the BAS, MAD, PAY and POS segments.      

SEGMENT_NO78A/N - 02Segment ID number - 80
SEGMENT_ID80A/N - 03Segment ID = DST
PAYROLL_NO83A/N - 05Current Payroll Number - year = 2 Digits and the payroll number.
PAY_DATE88A/N - 08Current Payroll - Pay Date (CCYYMMDD)
MVA_PAYROLL_NO96A/N - 05

Field is blank unless MVA processed.

Manual/Void - Payroll Number Adjusted will display on the EAR, FED, STA, DED, DST and NET segments.

Adjustments – Payroll Number Adjusted will display on the EAR, FED, STA, DED and DST segments.  The current Payroll Number processing will display on the NET Segment. 

MVA_DATE101A/N - 08

Field is blank unless MVA processed.

Pay Date (CCYYMMDD) for the payroll adjusted will display on the EAR, FED, STA, DED, DST and NET segments.  

*ORG_CODE109 A/N – 10NOT USED – Field is Blank
LAST_ACTIVE_DATE119A/N - 08MVA Effective Date (CCYYMMDD)
*POSITION_PCN1127A/N - 04NOT USED – Field is Blank
*FILLER1131A/N - 06NOT USED – Field is Blank
*PCA_NUMBER1137A/N - 05NOT USED – Field is Blank
*FILLER2142A/N - 02NOT USED – Field is Blank
*INDEX1144A/N - 04NOT USED – Field is Blank
*GRANT_PROJ_IND1148A/N - 01NOT USED – Field is Blank
*GRANT _NUMBER1149A/N - 06NOT USED – Field is Blank
*GRANT_PHASE1155A/N - 02NOT USED – Field is Blank
*EXP_SUB_OBJECT1157A/N - 04NOT USED – Field is Blank
AMOUNT_1161N - 11Earnings or deduction amount
EARNINGS_DED1172A/N - 04Deduction code or earnings code related to the adjustment
EARNINGS_HOURS1176N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
*POSITION_PCN2183A/N - 04NOT USED – Field is Blank
*FILLER3187A/N - 06NOT USED – Field is Blank
*PCA_NUMBER2193A/N - 05NOT USED – Field is Blank
*FILLER4198A/N - 02NOT USED – Field is Blank
*INDEX2200A/N - 04NOT USED – Field is Blank
*GRANT_PROJ_IND2204A/N - 01NOT USED – Field is Blank
*GRANT_NUMBER2205A/N - 06NOT USED – Field is Blank
*GRANT_PHASE2211A/N - 02NOT USED – Field is Blank
*EXP_SUB_OBJECT2213A/N - 04NOT USED – Field is Blank
AMOUNT2217N - 11Earnings or Deduction amount
EARNINGS_DED2228A/N - 04Deduction code or earnings code related to the adjustment. 
EARNING_HOURS2232N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
*POSITION_PCN3239A/N - 04NOT USED – Field is Blank
*FILLER5243A/N - 06NOT USED – Field is Blank
*PCA_NUMBER249A/N - 05NOT USED – Field is Blank
*FILLER6254A/N - 02NOT USED – Field is Blank
*INDEX3256A/N - 04NOT USED – Field is Blank
*GRANT_PROJ_IND3260A/N - 01NOT USED – Field is Blank
*GRANT_NUMBER3261A/N - 06NOT USED – Field is Blank
*GRANT_PHASE3267A/N - 02NOT USED – Field is Blank
*EXP_SUB_OBJECT3269A/N - 04NOT USED – Field is Blank
AMOUNT3273N - 11Earnings or Deduction amount.  If no earnings or deduction amount field is zero filled.
EARNINGS_DED3284A/N - 04Deduction code or earnings code related to the adjustment.  If no earnings or deduction code field is blank.
EARNINGS_HOURS3288N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
*POSITION_PCN4295A/N - 04NOT USED – Field is Blank
*FILLER7299A/N - 06NOT USED – Field is Blank
*PCA_NUMBER4305A/N - 05NOT USED – Field is Blank
*FILLER8310A/N - 02NOT USED – Field is Blank
*INDEX4312A/N - 04NOT USED – Field is Blank
*GRANT_PROJ_IND4316A/N - 01NOT USED – Field is Blank
*GRANT_NUMBER4317A/N - 06NOT USED – Field is Blank
*GRANT_PHASE4323A/N - 02NOT USED – Field is Blank
*EXP_SUB_OBJECT4325A/N - 04NOT USED – Field is Blank
AMOUNT4329N - 11Earnings or Deduction amount.  If no earnings or deduction amount field is zero filled.
EARNING_DED4340A/N - 04Deduction code or earnings code related to the adjustment.  If no earnings or deduction code field is blank.
EARNING_HOURS4344N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
*POSITION_PCN5351A/N - 04NOT USED – Field is Blank
*FILLER9355A/N - 06NOT USED – Field is Blank
*PCA_NUMBER5361A/N - 05NOT USED – Field is Blank
*FILLER10366A/N - 02NOT USED – Field is Blank
*INDEX5368A/N - 04NOT USED – Field is Blank
*GRANT_PROJ_IND5372A/N - 01NOT USED – Field is Blank
*GRANT_NUMBER5373A/N - 06NOT USED – Field is Blank
*GRANT_PHASE5379A/N - 02NOT USED – Field is Blank
*EXP_SUB_OBJECT5381A/N - 04NOT USED – Field is Blank
AMOUNT5385N - 11Earnings or Deduction amount.  If no earnings or deduction amount field is zero filled.
EARNING_DED5396A/N - 04Deduction code or earnings code related to the adjustment.  If no earnings or deduction code field is blank.
EARNING_HOURS5400N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
*POSITION_PCN6407A/N - 04NOT USED – Field is Blank
*FILLER11411A/N - 06NOT USED – Field is Blank
*PCA_NUMBER6417A/N - 05NOT USED – Field is Blank
*FILLER12422A/N - 02NOT USED – Field is Blank
*INDEX6424A/N - 04NOT USED – Field is Blank
*GRANT_PROJ_IND6428A/N - 01NOT USED – Field is Blank
*GRANT_NUMBER6429A/N - 06NOT USED – Field is Blank
*GRANT_PHASE6435A/N - 02NOT USED – Field is Blank
*EXP_SUB_OBJECT6437A/N - 04NOT USED – Field is Blank
AMOUNT6441N - 11Earnings or Deduction amount.  If no earnings or deduction amount field is zero filled.
EARNING_DED6452A/N - 04Deduction code or earnings code related to the adjustment.  If no earnings or deduction code field is blank.
EARNING_HOURS6456N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
*POSITION_PCN7463A/N - 04NOT USED – Field is Blank
*FILLER13467A/N - 06NOT USED – Field is Blank
*PCA_NUMBER7473A/N - 05NOT USED – Field is Blank
*FILLER14478A/N - 02NOT USED – Field is Blank
*INDEX7480A/N - 04NOT USED – Field is Blank
*GRANT_PROJ_IND7484A/N - 01NOT USED – Field is Blank
*GRANT_NUMBER7485A/N - 06NOT USED – Field is Blank
*GRANT_PHASE7491A/N - 02NOT USED – Field is Blank
*EXP_SUB_OBJECT7493A/N - 04NOT USED – Field is Blank
AMOUNT7497N - 11Earnings or Deduction amount.  If no earnings or deduction amount field is zero filled.
EARNING_DED7508A/N - 04Deduction code or earnings code related to the adjustment.  If no earnings or deduction code field is blank.
EARNING_HOURS7512N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
POSITION_PCN8519A/N - 04NOT USED – Field is Blank
FILLER15523A/N - 06NOT USED – Field is Blank
PCA_NUMBER8529A/N - 05NOT USED – Field is Blank
FILLER16534A/N - 02NOT USED – Field is Blank
INDEX8536A/N - 04NOT USED – Field is Blank
GRANT_PROJ_IND8540A/N - 01NOT USED – Field is Blank
GRANT_NUMBER8541A/N - 06NOT USED – Field is Blank
GRANT_PHASE8547A/N - 02NOT USED – Field is Blank
EXP_SUB_OBJECT8549A/N - 04NOT USED – Field is Blank
AMOUNT8553N - 11Earnings or Deduction amount.  If no earnings or deduction amount field is zero filled.
EARNING_DED8564A/N - 04Deduction code or earnings code related to the adjustment.  If no earnings or deduction code field is blank.
EARNING_HOURS8568N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
POSITION_PCN9575A/N - 04NOT USED – Field is Blank
FILLER17579A/N - 06NOT USED – Field is Blank
PCA_NUMBER9585A/N - 05NOT USED – Field is Blank
FILLER18590A/N - 02NOT USED – Field is Blank
INDEX9592A/N - 04NOT USED – Field is Blank
GRANT_PROJ_IND9596A/N - 01NOT USED – Field is Blank
GRANT_NUMBER9597A/N - 06NOT USED – Field is Blank
GRANT_PHASE9603A/N - 02NOT USED – Field is Blank
EXP_SUB_OBJECT9605A/N - 04NOT USED – Field is Blank
AMOUNT9609N - 11Earnings or Deduction amount.  If no earnings or deduction amount field is zero filled.
EARNING_DED9620A/N - 04Deduction code or earnings code related to the adjustment.  If no earnings or deduction code field is blank.
EARNING_HOURS9624N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
*POSITION_PCN10631A/N - 04NOT USED – Field is Blank
*FILLER19635A/N - 06NOT USED – Field is Blank
*PCA_NUMBER10641A/N - 05NOT USED – Field is Blank
*FILLER20646A/N - 02NOT USED – Field is Blank
*INDEX10648A/N - 04NOT USED – Field is Blank
*GRANT_PROJ_IND10652A/N - 01NOT USED – Field is Blank
*GRANT_NUMBER10653A/N - 06NOT USED – Field is Blank
*GRANT_PHASE9659A/N - 02NOT USED – Field is Blank
*EXP_SUB_OBJECT10661A/N - 04NOT USED – Field is Blank
AMOUNT10665N - 11Earnings or Deduction amount.  If no earnings or deduction amount field is zero filled.
EARNING_DED10676A/N - 04Deduction code or earnings code related to the adjustment.  If no earnings or deduction code field is blank.
EARNING_HOURS10680N - 07Hours for the adjustment if it is an earnings adjustment.  If no hours field is zero filled.
TOTAL687