Employee Setup Tables

EMPLOYEE SETUP
ADDL_PAY_DATA
REVISED: 02/06/2004
PEOPLESOFT RAW LENG 1 9 8 9
LEGACY NO CHANGES FOR 9.0
FIELD NAME RECORD_NAME SSN
TYPE Char Char
START POS
MASK
FORMAT 8 Upper 9
DESCRIPTION Value: ADDLPAY Social Security Number
KEY
TABLE
FIELD
TYPE
LEN
CONVERSION RULE
ISSUES / Comments
Extract Load will only furnish data where Object Code = 1143. PS Load program will look up SSN on PERS_NID to obtain EmplID. The first four fields in this table are exactly the same as table ADDL_PAY_EFFDT.
EMPLID
Char
18
11
11
Upper
EmplID
APSPS APSPS
PSXX-R-SSN NUM PSXX-C-AGCY (Agency) Num PSPF-C-ACCT (Activity Code) Num PSPH-CCLASS (JFD Class)
9 3
APSPSPF
APSPSPH EMPL_RCD Nbr 29 3 3 Empl Rcd Nbr K
Alpha
Extract file to include Agency, Department and Jobcode in extract file. Using Company (Agency), Department, and Jobcode from extract, PS Load will pull Empl_Rcd from PS_JOB to determine Employee Record number.
ERNCD
Char
32
Upper
Earnings Code Effective Date YYYYMMDD
EFFDT
Date
35
10
10
ADDL_SEQ
Nbr
45
Additional Pay Sequence Number
PS Department = Activity Code from Fund and Acct Line + "000" PS Company = Agency PS Jobcode = JFD/Class PS Load will use logic as follows: If Agency # = 131 or 566 Earn Code = HOU. If Extract Load will furnish agency Agency # = 585 Earn Code = #. EEA. Extract Load will furnish date that the data was extracted from PS Load will format to ddLegacy System. mon-yyyy. PS Load will start with 01 and increase by one for each row of data that is added for this earnings code. Due to the new GL Allocation process, these fields are no longer being populated in the ADDLPAY table Due to the new GL Allocation process, these fields are no longer being populated in the ADDLPAY table Due to the new GL Allocation process, these fields are no longer being populated in the ADDLPAY table Due to the new GL Allocation process, these fields are no longer being populated in the ADDLPAY table Due to the new GL Allocation process, these fields are no longer being populated in the ADDLPAY table
DEPTID
Char
47
10
10
Upper
Department
JOBCODE
Char
57
Upper
Job Code
POSITION_NBR
Char
63
Upper
Position Number
ACCT_CD
Char
71
25
25
Upper
Account Code
GL_PAY_TYPE
Char
96
Upper
General Ledger Pay Type
EMPLOYEE SETUP
ADDL_PAY_DATA
REVISED: 02/06/2004
PEOPLESOFT RAW LENG 102 103 104 105 106 107 108 103 111
FIELD NAME ADDL_PAY_SHIFT ADDL_PAY_SHIFT ADDL_PAY_SHIFT ADDL_PAY_SHIFT ADDL_PAY_SHIFT ADDL_PAY_SHIFT ADDL_PAY_SHIFT OTH_HRS HOURLY_RT
TYPE Char Char Char Char Char Char Char Sign Nbr
START POS
MASK
FORMAT Upper Value 1 2 3 J N
DESCRIPTION Additional Pay Shift Description 1 2 3 Use Job Shift Not Applicable Other Hours Hourly Rate
KEY
TABLE
FIELD
TYPE
LEN
1 1 1 1 1 1 1 1 1 1 1 1 1 1 8 4.219 12.6
CONVERSION RULE PS Load will default to 'N' (Not Applicable)
ISSUES / Comments
PS Load will default to 0. PS Load will default to 0. Extract Load will furnish the object codes eanrings amount. The earnings amount is only in the form of a Monthly Rate. If this is being setup for an employee with a Bi-Weekly pay cycle, PS Lod will annualize the amount, then divide by 26 prior 7 to distributing. PS Load will default to 'N' (Not Specified).
OTH_PAY ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON ADDLPAY_REASON SEPCHK EARNINGS_END_DT GOAL_AMT GOAL_BAL OK_TO_PAY DISABLE_DIR_DEP PRORATE_ADDL_PAY PRORATE_CUI_WEEKS PAY_PERIOD1
Sign Char Char Char Char Char Char Char Char Char Char Char Char Char Nbr Date Sign Sign Char Char Char Char Char
130 142 145 148 151 154 157 160 163 166 169 172 175 178 145 146 156 168 180 181 182 183 184
12 8.23 3 3 3 3 3 3 3 3 3 3 3 3 1 10 12 8.212 8.21 1 1 1 1 3 3 3 3 3 3 3 3 3 3 3 3 3 1 10 Upper Value A AWD BAS C JOB N O P Q RET S
Other Pay Reason for Additional Pay Description Anniversary Award Award Data Benefits Administration Credit Contract Pay Job Other Pay Not Specified Outstanding Contribution Performance Award President's Award Retirement Calculation Productivity Award Separate Check # Earnings End Date YYYYMMDD Goal Amount Current Goal Balance OK to Pay Disable Direct Deposit Prorate Additional Pay Prorate EI Weeks First Pay Period
APSPSPH
PSPH-A-SPEC- Signed PAY Dec
NOTE: Extract Load will furnish on Extract File the pay cycle the employee is on. PS LOAD will calculate this based on employee's Earnings Distribution record.
PS Load will default to 0. PS Load will default to NULL. PS Load will default to 0. PS Load will default to 0. PS Load will default to Blank. PS Load will default to 'N' PS Load will default to 'N' PS Load will default to 'N' PS Load will default to 'Y'. If employee is a Bi-Weekly employee, this field will be defualted to 'Y'. If employee is a Bi-Weekly employee, this field will be defualted to 'Y'.
1 1 1 1 1
Upper Upper Upper Upper Upper
PAY_PERIOD2
Char
185
Upper
Second Pay Period
PS Load will default to 'N".
PAY_PERIOD3 PAY_PERIOD4 PAY_PERIOD5 STATE LOCALITY
Char Char Char Char Char
186 187 188 189 195
1 1 1 6 10
1 1 1 6 10
Third Pay Period Fourth Pay Period Fifth Pay Period State Locality
PS Load will default to 'N". PS Load will default to 'N". PS Load will default to 'N". PS Load will default to 'OK'. PS Load will default to Blank.
EMPLOYEE SETUP
ADDL_PAY_DATA
REVISED: 02/06/2004
PEOPLESOFT RAW LENG
FIELD NAME
TYPE
START POS
MASK
FORMAT
DESCRIPTION
KEY
TABLE
FIELD
TYPE
LEN
TAX_PERIODS TAX_METHOD TAX_METHOD TAX_METHOD TAX_METHOD TAX_METHOD TAX_METHOD TAX_METHOD TAX_METHOD TAX_METHOD TAX_METHOD TAX_METHOD ADDL_PAY_FREQUENCY ADDL_PAY_FREQUENCY ADDL_PAY_FREQUENCY ADDL_PAY_FREQUENCY ADDL_PAY_FREQUENCY ADDL_PAY_FREQUENCY ADDL_PAY_FREQUENCY ADDL_PAY_FREQUENCY ADDL_PAY_FREQUENCY ADDL_PAY_FREQUENCY DED_TAKEN DED_TAKEN DED_TAKEN DED_TAKEN DED_TAKEN DED_TAKEN DED_SUBSET_ID DED_TAKEN_GENL DED_TAKEN_GENL DED_TAKEN_GENL DED_TAKEN_GENL DED_TAKEN_GENL DED_TAKEN_GENL DED_SUBSET_GENL PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE
Nbr Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char
205 207 208 209 210 211 212 213 214 215 216 217 208 208 208 208 208 208 208 208 208 208 209 209 209 209 209 209 210 213 214 215 216 217 218 214 217 219 221 223 225 227 229 231 233 235 237
2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 3 2 2 2 2 2 2 2 2 2 2 2
2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 3 2 2 2 2 2 2 2 2 2 2 2 Upper Value A B C G L M P S X Upper Value A B D M P Q S W Upper Value D N R S Upper Upper Value D N R S Upper Upper Value 0 10 11 14 1Y 1Z 20 21 25
Tax Periods Tax Method Description Annualized Bonus Cumulative Aggregate Lump Sum Commission Specified on Paysheet Supplemental Special Supplemental Tax Frequency Description Annually Biweekly Daily Monthly Use Pay Group Frequency Quarterly Semimonthly Weekly Deductions Taken Description Deduction Table Governs None No Override Deduction Table Subset Governs Deduction Subset ID General Deductions Taken Description Deduction Table Governs None No Override Deduction Table Subset Governs General Ded Subset ID Plan Type Description General Deduction Medical Dental Vision Dental - Dependents Medical - Dependents Life Supplemental Life Dependent Life
CONVERSION RULE ISSUES / Comments PS Load will default to '1' (Spread tax for the earning over 1 pay period). PS Load will default to 'P' (Specififed on Paysheet).
PS Load will default to 'P' (Use Pay Group Frequency)
PS Load will default to 'N'.
PS Load will leave Blank.
PS Load will default to Blank. PS Load will default to Blank.
EMPLOYEE SETUP
ADDL_PAY_DATA
REVISED: 02/06/2004
PEOPLESOFT RAW LENG 239 241 243 245 247 249 251 253 255 257 259 261 263 265 267 269 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
FIELD NAME PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE
TYPE Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char
START POS
MASK 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
FORMAT 27 2X 30 47 48 49 4Y 4Z 50 51 60 61 70 7Y 7Z 82
DESCRIPTION Supplemental Life - 1st 20000 Supp Life > $50,000 Short-Term Disability Nonelective Contributions Employer Only Section 457 OPERS Administrative Fee Sick Vacation Flex Spending Health U.S. Flex Spending Dependent Care PERS PERS 3 PERS 2 Pension Plan 1 - U.S.
KEY
TABLE
FIELD
TYPE
LEN
CONVERSION RULE
ISSUES / Comments
BUSINESS_UNIT COMP_RATECD RECORD_SOURCE FILLER
Char Char Char Char
219 224 230 231 Total Length
5 6 1 1113 1466
5 6 1
Upper Upper Upper
Business Unit Comp Rate Code Record Source Spaces
APSPS
PSXX-C-AGCY Numeric
Extract Load will furnish. Business Unit is the agency code followed by two zeroes. Example: Business Unit for 3 agency "566" is "56600". PS Load will default to Blank. PS Load will default to 'O'.
Due to the new GL Allocation process, these fields are no longer being populated in the ADDLPAY table
EMPLOYEE SETUP
ADDL_PAY_EFFDT
REVISED: 02/06/2004
TYPE Char Char
START POS
MASK
FORMAT 8 Upper 9
DESCRIPTION Value: ADDLEFF Social Security Number
KEY
TABLE
FIELD
TYPE
LEN CONVERSION RULE
ISSUES / Comments
Extract Load will only furnish data where Object Code = 1143. Except for field EFFDT, this extract is exactly the same as ADDL_PAY_ERNCD.
EMPLID
Char
18
11
11 Upper
EmplID
APSPS APSPS
PSXX-R-SSN
Num 3
PS Load program will look up SSN on PERS_NID to obtain EmplID. Extract file to include Agency, Department and Jobcode in extract file. Using Company (Agency), Department, and Jobcode from extract, PS Load will pull Empl_Rcd from PS_JOB to determine Employee Record number.
PSXX-C-AGCY Num (Agency) PSPF-C-ACCT (Activity Code) Num
APSPSPF
PSPH-C-CLASS Alpha (JFD Class)
ERNCD
Char
32
3 Upper
Earnings Code
Extract Load will furnish Agency #.
PS Department = Activity Code from Fund and Acct Line + "000" PS Company = Agency PS Jobcode = JFD/Class PS Load will use logic as follows: If Agency # = 131 or 566 Earn Code = HOU. If Agency # = 585 Earn Code = EEA.
EFFDT RECORD_SOURCE RECORD_SOURCE RECORD_SOURCE RECORD_SOURCE FILLER
Date Char Char Char Char Char
35 45 46 47 48 46 Total Length
10 1 1 1 1 1298 1346
10 1 1 1 1 Upper Value B O
Effective Date YYYYMMDD Record Source Description Batch On-line Spaces
Extract Load will furnish date that the data was extracted PS Load will format to ddfrom Legacy System. mon-yyyy. PS Load will default to 'O' for On-Line.
EMPLOYEE SETUP
ADDL_PAY_ERNCD
REVISED: 02/06/2004
LEGACY
TYPE Char Char
START POS
MASK
FORMAT 8 Upper 9
DESCRIPTION Value: ADDLEARN Social Security Number
KEY
TABLE
FIELD
TYPE
LEN CONVERSION RULE
ISSUES / Comments
PS Load program will look up SSN on PERS_NID to obtain EmplID. Extract Load: Even If the employee has multiple APSPSPH segments where the PSPH-C-SPEC-PAYTYPE = "U", only create one record per Agency payroll position.
EMPLID
Char
18
11
11 Upper
EmplID
APSPS APSPS
PSXX-R-SSN PSXX-C-AGCY (Agency) PSPF-C-ACCT (Activity Code)
Num Num 3
Extract Load: Extract Load will only furnish data for the Additional Pay conversion where the Object Code = 1143 and employee is active .
APSPSPF
Num
PSPH-C-CLASS Alpha (JFD Class)
Extract file to include Agency, Department and Jobcode in extract file. Using Company (Agency), Department, and Jobcode from extract, PS Load will pull Empl_Rcd from PS_JOB to determine Employee Record number.
PS Department = Activity Code from Fund and Acct Line + "000" PS Company = Agency PS Jobcode = JFD/Class PS Load will use logic as follows: If Agency # = 131 or 566, Earn Code = HOU. If Agency # = 585, Earn Cojde = EEA.
ERNCD RECORD_SOURCE RECORD_SOURCE RECORD_SOURCE RECORD_SOURCE FILLER
Char Char Char Char Char Char Total Length
32 35 36 37 38 36
3 1 1 1 1 1308 1346
3 Upper 1 1 1 1 Upper Value B O
Earnings Code Record Source Description Batch On-line Spaces
Extract Load will furnish Agency # PS Load will default to 'O' for On-Line.
EMPLOYEE SETUP
ADDL_PAY_ERNCD
REVISED: 02/06/2004
NO CHANGES FOR 9.0
EMPLOYEE SETUP
BOND_LOG
REVISED: 02/06/2004
PEOPLESOFT RAW START POS LENG MASK FORMAT 1 8 8 Upper 9 9 9
LEGACY
TYPE Char Char
DESCRIPTION Value: BONDLOG Social Security Number
KEY
TABLE
FIELD
TYPE
LEN CONVERSION RULE
ISSUES / Comments
EMPLID
Char
18
11
11 Upper
EmplID
APSPS
PSXX-R-SSN
NUM ALPHA NUM NUM ALPHA NUM ALPHA
9 3 4 9 1 9 1
PS Load will match to NATIONAL_ID of PERS_NID record to pull EMPLID. Extract Load will give Employee SSN.
Extract Load: Only extracting information for employees who are currently active at the time of the extract and who have active Savings Bond deductions.
BOND_ID BOND_OWNER_ID
Char Char
29 32 34
3 2 1
3 Upper 2 Upper 1 Upper Value B C N
Savings Bond ID Bond Owner ID Bond Other Registrant Type Description Beneficiary Co-Owner No Other Bond Registrant Bond Other Registrant Id Bond Activity Seq #
K K K
BOND_OTH_REG_TYPE Char
PSSB-C-SERIES APSPSSB PSSB-A-DENOMINATION PSSB-R-OWNER-SSN APSPSSB PSSB-C-CB PSSB-R-OWNER-SSN APSPSSB PSSB-C-CB
Extract Load will furnish. See PS Load Documentation. See PS Load Documentation.
BOND_OTH_REG_ID BOND_LOG_SEQ
Char Nbr
35 37
2 3
2 Upper 3
K K
APSPSSB PSSB-R-CB-SSN
NUM
BOND_LOG_STATUS BOND_LOG_STATUS BOND_LOG_STATUS BOND_LOG_STATUS BOND_LOG_STATUS BOND_LOG_STATUS BOND_LOG_STATUS REVERSED FORM_ID PAYCHECK_NBR
Char Char Char Char Char Char Char Char Char Nbr
40 41 42 43 44 45 46 41 42 48
1 1 1 1 1 1 1 1 6 15
1 1 1 1
Upper Value D F
1 N 1 1 1 6 15 R T Upper Upper
Bond Activity Status Description Funds Disbursed Refunded Balance Funds Not Ready to Disburse Funds Ready to Disburse Transferred Balance Reversed Form Identification Paycheck Number Paycheck Issue Date YYYYMMDD Bond Collection Amount Bond Disbursement Amount Bond Purchase Units Bond Accumulated Amount Company Pay Group Pay Period End Date YYYYMMDD
APSPSSB PSSB-A-BALANCE
SIGNED
See PS Load Documentation. PS Load will deafult to '001'. Extract Load will furnish using the following logic: If balance > zeroes, but balance < purchase price, insert with "N" If balance > zeroes, and balance >= purchase price, insert with "R" If balance = zeroes, insert with "D" (PS Load will make this Dete
MAKE SURE TO TEST THIS BALANCE IN CONVERSION TESTING!@!@
CHECK_DT BOND_COLLECT_AMT BOND_DISBURSE_AMT BOND_PURCH_UNITS BOND_ACCUM_AMT COMPANY PAYGROUP PAY_END_DT
Date Sign Nbr Nbr Sign Char Char Date
63 73 82 90 93 102 105 108
10 10 9 5.28 3 9 5.23 3 10 5.2 3
Extract Date
PS Load will default to 'N" PS Load will default to 'CHECK'. PS Load will default to all 9s. PS Load will format date, This date is the date the furnished by Extract Load, to data was pulled from the dd_mon_yyyy. Legacy System. PS Load will default to '0'. PS Load will default to '0'. PS Load will default to '0'.
APSPSSB PSSB-A-BALANCE
SIGNED
3 Upper 3 Upper 10
Extract Load will furnish. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank.
EMPLOYEE SETUP
BOND_LOG
REVISED: 02/06/2004
PEOPLESOFT RAW START POS LENG MASK FORMAT 118 1 1 Upper 119 1 1 Upper 120 1 1 Value 121 1 1 S 120 1224 Total Length 1351
LEGACY
FIELD NAME OFF_CYCLE AP_STATUS AP_STATUS AP_STATUS FILLER
TYPE Char Char Char Char Char
DESCRIPTION Off Cycle ? AP Status Description Sent to AP Spaces
KEY
TABLE
FIELD
TYPE
LEN CONVERSION RULE PS Load will default to Blank. PS Load will default to Blank.
ISSUES / Comments
EMPLOYEE SETUP
BOND_LOG
REVISED: 02/06/2004
NO CHANGES FOR 9.0
EMPLOYEE SETUP
BOND_LOG
REVISED: 02/06/2004
NO CHANGES FOR 9.0
EMPLOYEE SETUP
BOND_SPEC
REVISED: 02/06/2004
PEOPLESOFT RAW LENG MASK 1 8 9 9
FIELD NAME TYPE RECORD_NAME Char SSN Char
START POS
FORMAT DESCRIPTION Value: BONDSPEC 8 Upper Social Security Number 9
KEY
TABLE
FIELD
TYPE
LEN
CONVERSION RULE
ISSUES / Comments
EMPLID
Char
18
11
11 Upper
EmplID
APSPS
PSXX-R-SSN
NUM
PS Load will match to NATIONAL_ID of PERS_NID record to pull EMPLID. Extract Load will give Employee SSN.
COMPANY
Char
29
3 Upper
Company
APSPS
PSXX-C-AGCY
NUM
Extract Load will furnish.
**Only pull employees with an active position who also have an active Savings Bond PS Load will use agency # to assign company code. PS Load will validate # by comparing to Company Table.
APSPS
PSXX-D-BEGIN-CYMD PSXX-D-END-CYMD PSSB-D-BEGIN-CYMD PSSB-D-END-CYMD
NUM NUM NUM NUM
8 8 8 8
EFFDT FILLER
Date Char
32 42
10 1302
10
Effective Date YYYYMMDD Spaces
APSPSSB K
Extract Load will furnish based on logic: PSXX-DBEGIN-CYMD MUST BE <= CONVERSION DATE PSXX-D-END-CYMD MUST BE >= CONVERSION DATE and PSSB-D-BEGIN-CYMD MUST BE <= CONVERSION DATE PS Load will convert PSSB-D-END-CYMD MUST date to ORACLE format BE >= CONVERSION DATE of dd-mon-yyyy.
Total Length 1343 **When active position is found, then go to the APSPSSB (child record)
EMPLOYEE SETUP
BOND_SPEC_DATA
REVISED: 02/06/2004
PEOPLESOFT RAW LENG 1 8
LEGACY
FIELD NAME RECORD_NAME
TYPE Char
START POS
MASK
FORMAT 8 Upper
DESCRIPTION Value: BONDSPDA
KEY
TABLE
FIELD
TYPE
LEN
CONVERSION RULE
ISSUES / Comments
SSN
Char
Social Security Number
EMPLID
Char
18
11
11 Upper
EmplID
APSPS
PSXX-R-SSN
NUM
Extract Load will include only the most current rows of data for all employees based on the conversion rule in the Development Request. PS Load program is looking up SSN on PERS_NID to obtain EmplID. Extract Load will furnish SSN. PS Load will match to NATIONAL_ID of PERS_NID record to pull EMPLID.
COMPANY
Char
29
3 Upper
Company
APSPS
PSXX-C-AGCY
NUM
COMPANY = Agency #, Extract Load wil give Company. Each bond ID will have it's own effective date comes from Extract Load.
For every record here with a unique EFFDT, there must be one record in BOND_SPEC with matching EFFDT. PS Load will use agency # to assign company code. PS Load will validate # by comparing to Company Table.
EFFDT
Date
32
10
10
Effective Date
APSPSSB
PSSB-D-BEGIN-CYMD
NUM
PRIORITY
Nbr
42
Priority
APSPSSB
PSSB-R-DED
NUM
BOND_ID BOND_OWNER_ID
Char Char
45 48
3 2
3 Upper 2 Upper
Savings Bond ID Bond Owner ID Bond Other Registrant Type Description Beneficiary Co-Owner No Other Bond Registrant Bond Other Registrant Id Address Type
APSPSSB APSPSSB
PSSB-C-SERIES PSSB-A-DENOMINATION PSSB-R-OWNER-SSN
ALPHA NUM NUM
3 4 9
PS Load will initialize the Priority numbering sequence starting with 001. These 2 fields will be used by Extract Load to determine the type of bond purchased. See PS Load documentation. See PS Load documentation.
The PSSB-R-DED is included in the extract for the legacy programmer's benefit. He/she needs to know which segment the extract record was created from.
BOND_OTH_REG_TYPE BOND_OTH_REG_TYPE BOND_OTH_REG_TYPE BOND_OTH_REG_TYPE
Char Char Char Char
50 51 52 53 54 51 53
1 1 1 1 1 2 4
1 1 1 1
Upper Value B C
APSPSSB
PSSB-C-CB
ALPHA
See worksheet for Delivered bond ID's EE = Employee NA = Other If 'C' then insert 'C' 'B' then 'B' Else, 'N'.
BOND_OTH_REG_TYPE Char BOND_OTH_REG_ID ADDRESS_TYPE Char Char
1 N 2 Upper 4 Upper
APSPSSB
PSSB-R-CB-SSN
NUM
See PS Load documentation. PS Load will default to 'HOME'.
BOND_DEDUCT_AMT AMOUNT_PCT
Nbr Sign
57 65
8 7 3.2-
5.2
Bond Deduction Amount Percent Amount
APSPSSB
PSSB-A-DED
SIGNED NUMERI C
Extract Load will furnish. PS Load will default to '0'.
EMPLOYEE SETUP
BOND_SPEC_DATA
REVISED: 02/06/2004
PEOPLESOFT RAW LENG
LEGACY
FIELD NAME
TYPE
START POS
MASK
FORMAT
DESCRIPTION
KEY
TABLE
FIELD
TYPE
LEN
CONVERSION RULE
EXCESS PARTIAL_ALLOWED BOND_DLVY_ID FILLER
Char Char Char Char Total Length
72 73 74 76
1 1 2 1268 1347
1 Upper 1 Upper 2 Upper
Excess Partial Allowed Bond Delivery ID Spaces
ISSUES / Comments If more than one Bond is being purchased by an employee, then only one of the Bond-Spec-Data rows can have a Y PS Load will set first bond entered, the other rows to 'Y'. will default to N. PS Load will default to 'Y PS Load will default to EE.
NOTE: For every employee having a Bond(s) setup in this table, PS Load will generate a row in GENL_DED_CD and GENL_DEDUCTION table for the employee. See GENL_DED_CD (bond) and GENL_DEDUCTION (bond) conversion templates.
EMPLOYEE SETUP
BOND_SPEC_DATA
REVISED: 02/06/2004
NO CHANGES FOR 9.0
EMPLOYEE SETUP
BOND_SPEC_DATA
REVISED: 02/06/2004
NO CHANGES FOR 9.0
TION (bond) conversion
EMPLOYEE SETUP
DEPT_BUDGET_ERN
Revised: 11/23/09
FIELD NAME RECORD_NAME SSN EMPLID EMPL_RCD SETID DEPTID FISCAL_YEAR POSITION_POOL_ID SETID_JOBCODE JOBCODE POSITION_NBR EFFDT EFFSEQ ERNCD BUDGET_SEQ ACCT_CD GL_PAY_TYPE BUDGET_AMT HP_EXCESS DIST_PCT PERCENT_EFFORT FUNDING_END_DT HP_USED_DISTRIBUTN HP_FRINGE_GROUP HP_REDIRECT_ACCT FILLER
TYPE Char Char Char Nbr Char Char Nbr Char Char Char Char Date Nbr Char Nbr Char Char Nbr Char Nbr Nbr Date Char Char Char Char
Start Position RAW LENGTH MASK FORMAT 1 8 8 Upper 9 9 9 18 11 11 Upper 29 3 3 32 5 5 Upper 37 10 10 Upper 47 4 4 51 3 3 Upper 54 5 5 Upper 59 6 6 Upper 65 8 8 Upper 73 10 10 83 3 3 86 3 3 Upper 89 2 2 91 25 25 Upper 116 6 6 Upper 122 19 15.3 141 1 1 Upper 142 7 3.3 149 6 3.2 155 10 10 165 1 1 Upper 166 5 5 Upper 171 25 25 Upper 196 1148 Total Length 1343
DESCRIPTION Value: DEPTBGT Social Security Number EmplID Empl Rcd Nbr Setid Department Fiscal Year Position Pool ID Jobcode Setid Job Code Position Number Effective Date - YYYYMMDD Effective Sequence Earnings Code Budget Sequence Nbr Account Code General Ledger Pay Type Budget Amount Allow Overspend Percent of Distribution % Effort Funding End Date Used by Distribution Process Fringe Group Redirect Account Code Spaces
EMPLOYEE SETUP
EMPLOYMENT
REVISED: 08/18/2008
FIELD NAME RECORD_NAME SSN EMPLID EMPL_RCD BENEFIT_RCD_NBR HOME_HOST_CLASS HOME_HOST_CLASS HOME_HOST_CLASS HOME_HOST_CLASS HIRE_DT
TYPE Char Char Char Nbr Nbr Char Char Char Char Date
Start Position RAW LENGTH MASK FORMAT 1 8 8 Upper 9 9 9 18 11 11 Upper 29 3 3 32 3 3 35 1 1 Upper 36 1 1 Value 37 1 1 M 38 1 1 S 36 10 10
DESCRIPTION Value: EMPLOYME Social Security Number EmplID Empl Rcd Nbr Benefit Record Number Home/Host Classification Description Home Host Hire Date - YYYYMMDD
KEY K K
CHANGES FOR 9.0
The Rehire date is now automatically populated for all the rows even if the Employee is not rehired. The REHIRE_DT field would contain the same information as the HIRE_DT as long as the employee is not rehired. To check for employees who have been rehired, you can check if the two dates match. If they do then the employee has not been rehired. And if they dont then the employee was rehired on the date specified in the REHIRE_DT field and the HIRE_DT field in that case would contain the original Hire date of the employee. REHIRE_DT CMPNY_SENIORITY_DT SERVICE_DT PROF_EXPERIENCE_DT LAST_VERIFICATN_DT EXPECTED_RETURN_DT TERMINATION_DT LAST_DATE_WORKED LAST_INCREASE_DT OWN_5PERCENT_CO BUSINESS_TITLE REPORTS_TO SUPERVISOR_ID PROBATION_DT SECURITY_CLEARANCE SECURITY_CLEARANCE SECURITY_CLEARANCE SECURITY_CLEARANCE SECURITY_CLEARANCE SECURITY_CLEARANCE SECURITY_CLEARANCE SECURITY_CLEARANCE SECURITY_CLEARANCE SECURITY_CLEARANCE SECURITY_CLEARANCE COUNTRY_CODE PHONE TIME_RPT_LOC JOB_REPORTING DED_TAKEN DED_TAKEN DED_TAKEN DED_TAKEN DED_TAKEN DED_TAKEN Date Date Date Date Date Date Date Date Date Char Char Char Char Date Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char 46 56 66 76 86 96 106 116 126 136 137 167 175 186 196 197 198 199 200 201 202 203 204 205 206 197 200 224 230 231 232 233 234 235 236 10 10 10 10 10 10 10 10 10 1 30 8 11 10 1 1 1 1 1 1 1 1 1 1 1 3 24 6 1 1 1 1 1 1 1 10 10 10 10 10 10 10 10 10 1 30 8 11 10 1 1 1 1 1 1 1 1 1 1 1 3 24 6 1 1 1 1 1 1 1 Rehire Date - YYYYMMDD Company Seniority Date - YYYYMMDD Service Date - YYYYMMDD Longevity Date - YYYYMMDD Last Verification Date - YYYYMMDD Expected Return Date - YYYYMMDD Termination Date - YYYYMMDD Last Date Worked - YYYYMMDD Date Last Increase - YYYYMMDD Owns 5% (or More) of Company Business Title Reports To Position Number Supervisor ID Probation Date - YYYYMMDD Security Clearance Description Not Required Classified Secret Top Secret Sensitive Compartmented Info Q Sensitive Q Non-Sensitive L (Atomic Energy Act) Other Country Code Telephone Time Reporting Location Job Reporting Required Deductions Taken Description Deduction Table Governs None No Override Deduction Table Subset Governs
Upper Mixed Upper Upper Upper Value 0 1 2 3 4 5 6 7 8 Upper Custom Upper Upper Upper Value D N R S
Blank, Not Available in 9.0 Blank, Not Available in 9.0
EMPLOYEE SETUP
EMPLOYMENT
REVISED: 08/18/2008
FIELD NAME DED_SUBSET_ID GVT_SCD_RETIRE GVT_SCD_TSP GVT_SCD_LEO GVT_SCD_SEVPAY GVT_SEVPAY_PRV_WKS GVT_MAND_RET_DT GVT_WGI_STATUS GVT_INTRM_DAYS_WGI GVT_NONPAY_NOA GVT_NONPAY_HRS_WGI GVT_NONPAY_HRS_SCD GVT_NONPAY_HRS_TNR GVT_NONPAY_HRS_PRB GVT_TEMP_PRO_EXPIR GVT_TEMP_PSN_EXPIR GVT_DETAIL_EXPIRES GVT_SABBATIC_EXPIR GVT_RTND_GRADE_BEG GVT_RTND_GRADE_EXP GVT_NOA_CODE GVT_CURR_APT_AUTH1 GVT_CURR_APT_AUTH2 GVT_APPT_EXPIR_DT GVT_CNV_BEGIN_DATE GVT_CAREER_CNV_DUE GVT_CAREER_COND_DT GVT_APPT_LIMIT_HRS GVT_APPT_LIMIT_DYS GVT_APPT_LIMIT_AMT GVT_SUPV_PROB_DT GVT_SES_PROB_DT GVT_SEC_CLR_STATUS GVT_CLRNCE_STAT_DT GVT_ERN_PGM_PERM GVT_OCC_SERS_PERM GVT_GRADE_PERM GVT_COMP_AREA_PERM GVT_COMP_LVL_PERM GVT_CHANGE_FLAG GVT_SPEP GVT_WGI_DUE_DATE GVT_DT_LEI GVT_FIN_DISCLOSURE GVT_FIN_DISCL_DATE GVT_TENURE GVT_DETL_BARG_UNIT GVT_DETL_UNION_CD NEXT_REVIEW_DT GVT_WELFARE_WK_CD TENURE_ACCR_FLG FTE_TENURE EG_GROUP FTE_FLX_SRVC CONTRACT_LENGTH CONTRACT_LENGTH CONTRACT_LENGTH
TYPE Char Date Date Date Date Nbr Date Char Nbr Char Nbr Nbr Nbr Nbr Date Date Date Date Date Date Char Char Char Date Date Date Date Nbr Nbr Nbr Date Date Char Date Char Char Char Char Char Char Char Date Date Char Date Char Char Char Date Char Char Nbr Char Nbr Char Char Char
Start Position RAW LENGTH MASK 232 3 235 10 245 10 255 10 265 10 275 2 277 10 287 1 288 3 291 3 294 7 301 7 308 7 315 7 322 10 332 10 342 10 352 10 362 10 372 10 382 3 385 3 388 3 391 10 401 10 411 10 421 10 431 4 435 3 438 6 444 10 454 10 464 1 465 10 475 2 477 4 481 3 484 2 486 3 489 1 490 2 492 10 502 10 512 1 513 10 523 1 524 4 528 3 531 10 541 2 543 1 544 4 548 6 554 4 558 1 559 1 560 1
3 10 10 10 10 2 10 1 3 3 4.2 4.2 4.2 4.2 10 10 10 10 10 10 3 3 3 10 10 10 10 4 3 6 10 10 1 10 2 4 3 2 3 1 2 10 10 1 10 1 4 3 10 2 1 1.2 6 1.2 1 1 1
FORMAT DESCRIPTION Upper Deduction Subset ID Service Comp Date - Retire - YYYYMMDD Service Comp Date - TSP - YYYYMMDD Service Comp Date - LEO - YYYYMMDD Service Comp Date - Sev Pay - YYYMMDD Severance Pay Previous Weeks Mandatory Retirement Date - YYYYMMDD Upper Current WGI Status Intermittent Days Worked Upper NonPay Nature of Action - Last Non-Pay Hours WGI Non-Pay Hours for SCD Career Tenure Hours Non-Pay Hours for Probation Temp Promotion Expires - YYYYMMDD Temporary Posn Change Expires - YYYYMMDD Date Detail Expires - YYYYMMDD Date Sabbatical Expires - YYYYMMDD Retained Grade Begins - YYYYMMDD Retained Grade Expires - YYYYMMDD Upper Nature of Action Code Upper Current Appointment Auth #1 Upper Current Appointment Auth #2 Appointment Expiration Date - YYYYMMDD Conv Begin Date - YYYYMMDD Conversion to Career Due - YYYYMMDD Career-Cond Conv Date - YYYYMMDD Appointment Limit in Hours Appointment Limit in Days Appointment Limit Amount Supv/Manager Probation Date - YYYYMMDD SES Probation Date - YYYYMMDD Upper Security Clearance Status Security Clearance Status Date - YYYYMMDD Upper Permanent Pay Plan - RIF Upper Permanent Occ Series - RIF Upper Permanent Grade - RIF Upper Comp/Area Level Upper Permanent Comp Level - RIF Upper Change Flag Upper Special Employment Program Within-Grade Increase Due Date - YYYYMMDD Date Last Equivalent Increase - YYYYMMDD Upper Financial Disclosure Required Financial Disclosure Due Date - YYYYMMDD Upper Highest Career Tenure Upper GVT Detail Bargaining Unit Upper GVT Detail Union Code Next Review Date - YYYYMMDD Upper Welfare to Work Upper Accrue Tenure Services FTE for Tenure Accrual Upper Service Calculation Group FTE for Flex Service Accrual Upper Contract Length Value Description 0 Not Applicable
KEY
CHANGES FOR 9.0 Blank, Not Available in 9.0 Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Zero, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Zero used for Fed Emps Blank, used for Fed Emps Zeros, used for Fed Emps Zeros, used for Fed Emps Zeros, used for Fed Emps Zeros, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Zeros, used for Fed Emps Zeros, used for Fed Emps Zeros, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, used for Fed Emps Blank, Not Available in 9.0 Blank, used for Fed Emps Blank, used for Fed Emps Zeros, Not Available in 9.0 Blank, Not Available in 9.0 Zeros, Not Available in 9.0 Blank, Not Available in 9.0
EMPLOYEE SETUP
EMPLOYMENT
REVISED: 08/18/2008
FIELD NAME CONTRACT_LENGTH CONTRACT_LENGTH CONTRACT_LENGTH APPOINT_END_DT NEE_PROVIDER_ID FA_PAY_PROGRAM FA_TYPE FA_ELIG_DT EDUC_LVL_AD_BTD OFFICIAL_LANG RELAT_TO_OWNER_NLD FILLER
TYPE Char Char Char Date Char Char Char Date Date Char Char Char
Start Position RAW LENGTH MASK 561 1 562 1 563 1 559 10 569 10 579 3 582 3 585 10 595 10 605 3 608 1 609 735 Total Length 1366
1 1 1 10 10 3 3 10 10 3 1
FORMAT 1 2 3 Upper Upper Upper
Upper Upper
DESCRIPTION <9 Month 9-10 Month 11-12 Month Appointment End Date - YYYYMMDD Provider ID Festive Advance Pay Program FA Holiday Type Festive Advance Eligible From - YYYYMMDD Educ Lvl -Adjsted Birth Date - YYYYMMDD Official Language Relation to Owner Spaces
KEY
CHANGES FOR 9.0
Blank, Not Available in 9.0 Blank, Not Available in 9.0 Blank, Not Available in 9.0 Blank, Not Available in 9.0 Blank, Not Available in 9.0 Blank, Not Available in 9.0 Blank, Not Available in 9.0
EMPLOYEE SETUP
FED_TAX_DATA
REVISED: 02/06/2004
PEOPLESOFT RAW START POS LENG 1 8
TYPE Char
MASK
FORMAT 8 Upper
DESCRIPTION Value: FEDTAX
KEY
TABLE
FIELD
TYPE
LENGTH
CONVERSION RULE Extract Load will furnish the most recent row of data for employees based on the guidelines in the DR. PS Load program is looking up SSN on PERS_NID to obtain EmplID.
ISSUES / Comments
SSN
Char
EMPLID
Char
18
11
11 Upper
EmplID
APSEMAG
EMAG-R-SSN
NUM
COMPANY
Char
29
3 Upper
Company
APSEMAG
EMAG-C-AGY
NUM
Company = Agency # Date = Effective Date of the first Job Record loaded for the employee. Extract file will provide based on the following crosswalk. If legacy value = "N" then send "E" on extract (E = "Exempt" in PS) , else set to "N" (N = "None" in PS).
EFFDT
Date
32
10
10
Effective Date YYYYMMDD
PS Load will use agency # to assign company code. PS Load will validate # by comparing to Company Table. PS Load will pull effective date from the first row of data on employee's Job record.
SPECIAL_FWT_STATUS Char SPECIAL_FWT_STATUS Char SPECIAL_FWT_STATUS Char SPECIAL_FWT_STATUS Char
42 43 44 45
1 1 1 1
1 Upper 1 Value 1 A 1 E
Special FWT Status Description Non-Resident Alien Exempt (not subject to FIT)
APSEMAG
EMAG-F-FIT
CHAR
SPECIAL_FWT_STATUS Char SPECIAL_FWT_STATUS Char
46 47
1 1
1 G 1 N
Maintain gross (no tax WH) None Extract file will provide based on the following crosswalk. If legacy value is M or H, send M (M = "Married" in PS), If legacy value is S or X, send S (S = "Single" in PS).
Leagacy System does not have a field fro addl percent values. State employees not subject to FUT.
FWT_MAR_STATUS FWT_MAR_STATUS FWT_MAR_STATUS FWT_MAR_STATUS
Char Char Char Char
43 43 43 43
1 1 1 1
1 1 1 1
Upper Value M S
FWT Marital Status Description Married Single
APSEMAG
EMAG-C-MARITAL-STATUS CHAR
Extract file will send "Y" or "N" based on Annuity participation in legacy system. APSPS APSPSRD APSEMAG PSXX-KEY PSRD-C-AORG EMAG-R-EXEMPT NUM ALPH A NUM 17 4 2 Annuity AORG codes are: SAST, SAED Extract file will provide.
FWT_MAR_STATUS FWT_ALLOWANCES
Char Nbr
43 44
1 3
1 3
Extract file.
FWT Allowances
EMPLOYEE SETUP
FED_TAX_DATA
REVISED: 02/06/2004
PEOPLESOFT RAW START POS LENG 47 8
FIELD NAME FWT_ADDL_AMT
TYPE Nbr
MASK FORMAT 5.2
DESCRIPTION FWT Additional Amount FWT Additional Percentage Exempt from FUT
KEY
TABLE APSEMAG
FIELD TYPE EMAG-A-W4-ADDL-FIT SIGN
LENGTH 6
CONVERSION RULE Extract file will provide.
ISSUES / Comments Leagacy System does not have a field fro addl percent values. State employees not subject to FUT.
FWT_ADDL_PCT FUT_EXEMPT
Nbr Char
55 61
6 1
2.3 1 Upper
PS Load will Default = 0 PS Load will Default = "Y" Extract file will provide based on the following crosswalk. If legacy value is B, send M (M = "Married, both filing" in PS), If legacy value is N, send N (N = "Not Applicable" in PS), If legacy value is L, send S (S = "Single"
EIC_STATUS EIC_STATUS EIC_STATUS EIC_STATUS EIC_STATUS EIC_STATUS
Char Char Char Char Char Char
62 63 64 65 66 67
1 1 1 1 1 1
1 Upper 1 Value 1 M 1 N 1 S 1 U
Earned Income Credit Status Description Married, both spouses filing Not applicable Single,or Head of Household Married without spouse filing
APSEMAG
EMAG-C-EIC
ALPHA
STATUTORY_EE
Char
63
1 Upper
Statutory Employee
DECEASED
Char
64
1 Upper
Deceased
APSEMAG
EMAG-C-TERM-REAS
ALPHA
This is only used if the employee works for the employer but is not an employee under common law rules PS Load will Default = N This field needs to be Extract Load will furnish. Set furnished by Extract Deceased to "Y" if the TERM- Load in case 1 Jan GoREAS = "DE". Live is changed. Extract will provide. If employee has current active retirement plan in legacy system, send 'Y' else send 'N' on extract.
PENSION_PLAN LEGAL_REP
Char Char
65 66
1 1
1 Upper 1 Upper
Retirement Plan
APSPS APSPSRD
PSXX-KEY PSRD-C-AORG
NUM ALPH A
Retirement AORG codes are: SROP, SROL, SRTD, 17 SRTR, SRTD, SRTE, SRTS, 4 SRTX, SRWL, OSBI Default = N PS Load
EMPLOYEE SETUP
FED_TAX_DATA
REVISED: 02/06/2004
PEOPLESOFT RAW LENG
FIELD NAME
TYPE
START POS
MASK
FORMAT
DESCRIPTION
KEY
TABLE
FIELD
TYPE
LENGTH CONVERSION RULE Extract file will send "Y" or "N" based on Annuity participation in legacy system. Annuity AORG codes are: SAST, SAED Default = N Blank Blank Blank Blank Blank
ISSUES / Comments
DEFERRED_COMP USE_TOTAL_WAGE LAST_ACTION W4_PRCSS W5_PRCSS LOCK_IN_RECVD LOCK_IN_LIMIT
Char Char Char Char Char Char Nbr
67 68 69 70 71 72 73
1 1 1 1 1 1 3
1 1 1 1 1 1 3
Upper Upper Upper Upper Upper Upper
APSPS APSPSRD
PSXX-KEY PSRD-CNUM AORG ALPHA
17 4
Extract file. PS Load PS Load PS Load PS Load PS Load will Default to "N" PS Load will Default to "000" Extract Load will furnish. This is the date when Extract Load pulled the data from the Legacy System. The date is based on the PS Load wil default to Blank. online entry Default = USA PS Load will default to 'N'.
LAST_UPDATE_DATE DATE_OF_ENTRY COUNTRY FORM_1001_RECD FORM_1001_RECD FORM_1001_RECD FORM_1001_RECD FORM_1001_RECD
Date Date Char Char Char Char Char Char
76 86 96 99 100 101 102 103 100 110 120 121 122 123 124 121 131 141 150 160 170 171 181 182 183 Total Length
10 10 3 1 1 1 1 1 10 10 1 1 1 1 1 10 10 9 10 10 1 10 1 1 1161 1365
10 10 3 1 1 1 1 1 10 10 1 1 1 1 1 10 10 9 Upper 10 10 Upper 1 Upper 10 1 Upper 1 Upper
Upper Upper Value N X Y
FORM_1001_SUBMT_DT Date FORM_1001_EXP_DT FORM_8233_RECD FORM_8233_RECD FORM_8233_RECD FORM_8233_RECD FORM_8233_RECD Date Char Char Char Char Char
Upper Value N X Y
FORM_8233_SUBMT_DT Date FORM_8233_EXP_DT TAXPAYER_ID_NO TREATY_EXP_DT TREATY_ID FORM_1078_RECD FORM_1078_SUBMT_DT THIRDPARTY_SICKPAY W4_NAME_CHECK FILLER Date Char Date Char Char Date Char Char Char
YYYYMMDD Date of Entry YYYYMMDD Country Form W8 Recd? Description No Not Applicable Yes W8 In Effect Date YYYYMMDD W8 Expiration Date YYYYMMDD Form 8233 Recd? Description No Not Applicable Yes Form 8233 Submission Date - YYYYMMDD 8233 Expiration Date YYYYMMDD Taxpayer ID Number Treaty Exp Date YYYYMMDD Treaty ID Form W9 Received W9 Submit Date YYYYMMDD Third-party sick pay W4 Name Check Spaces
Pull Date
PS Load wil default to NULL. W8 In Effect Date PS Load wil default to NULL. W8 Expiration Date PS Load will default to 'N'.
PS Load wil default to NULL. PS Load wil default to NULL. PS Load wil default to Blank. PS Load wil default to NULL. PS Load wil default to Blank. PS Load wil default to 'N'. PS Load wil default to NULL. PS Load wil default to Blank. PS Load will default to 'N'.
EMPLOYEE SETUP
GARN_RULE
REVISED: 02/06/2004
FIELD NAME RECORD_NAME SSN EMPLID COMPANY GARNID STATE_GARN_LAW GARN_RULE_ID GARN_DED_SW GARN_EX_AMT GARN_VAR_FREQUENCY GARN_DEP_EX_CNT GARN_ALLOW_CNT GARN_EX_MIN GARN_EX_MAX FORM_668W_YR FILLER
TYPE Char Char Char Char Char Char Char Char Nbr Char Nbr Nbr Nbr Nbr Char Char
START POS 1 9 18 29 32 38 44 54 55 64 65 68 71 80 89 93 Total Length
RAW LENGTH MASK FORMAT 8 8 Upper 9 9 11 11 Upper 3 3 Upper 6 6 Upper 6 6 Upper 10 10 Upper 1 1 Upper 9 6.2 1 1 Upper 3 3 3 3 9 6.2 9 6.2 4 4 1251 1343
DESCRIPTION Value: GARNRULE Social Security Number EmplID Company Garnish ID Garnish Law Source Garnish Rule ID Garnishment Deduction SW Garnish Exempt Amount Garnish Variable Frequency Garnish Dependent/Exempt Count Garnish Allowance Count Minimum Exemption Maximum Exemption Form 668-W Effective Year Spaces
KEY
NO CHANGES FOR 9.0
K K K K K
EMPLOYEE SETUP
GARN_SCHED
REVISED: 02/06/2004
FIELD NAME RECORD_NAME SSN EMPLID COMPANY GARNID PAY_FREQUENCY PAY_PERIOD PAY_PERIOD PAY_PERIOD PAY_PERIOD PAY_PERIOD PAY_PERIOD PAY_PERIOD GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_PCT GARN_DED_AMT CMPNY_FEE_PCT CMPNY_FEE_AMT PAYEE_FEE_PCT PAYEE_FEE_AMT FILLER
TYPE Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Nbr Nbr Nbr Nbr Nbr Nbr Char
START POS 1 9 18 29 32 38 43 44 45 46 47 48 49 44 44 44 44 44 44 44 44 44 45 51 60 66 75 81 90 Total Length
RAW LENGTH MASK FORMAT 8 8 Upper 9 9 11 11 Upper 3 3 Upper 6 6 Upper 5 5 Upper 1 1 Upper 1 1 Value 1 1 1 1 1 2 1 1 3 1 1 4 1 1 5 1 1 Upper 1 1 Value 1 1 G 1 1 H 1 1 M 1 1 P 1 1 R 1 1 S 1 1 T 6 3.2 9 6.2 6 3.2 9 6.2 6 3.2 9 6.2 1254 1357
DESCRIPTION Value: GARNSCHD Social Security Number EmplID Company Garnish ID Pay Frequency Pay Period Description First Second Third Fourth Fifth Garnish Deduction Calc Routine Description Greater of %DE or Amount Greater of %Gross or Amount Maximum Allowed % DE + Amount % Gross + Amount No exempt; %DE + Amt No exempt; % of Gross Garnish Deduct DE Percent Garnish Flat Deduction Amount Company's Voucher Fee Percent Company's Voucher Fee Amount Payee's Voucher Fee Percent Payee's Voucher Fee Amount Spaces
KEY
NO CHANGES FOR 9.0
K K K K K
EMPLOYEE SETUP
GARN_SPEC
REVISED: 02/06/2004
FIELD NAME RECORD_NAME SSN EMPLID COMPANY GARNID GARN_STATUS GARN_STATUS GARN_STATUS GARN_STATUS GARN_STATUS GARN_STATUS GARN_STATUS GARN_TYPE GARN_TYPE GARN_TYPE GARN_TYPE GARN_TYPE GARN_TYPE GARN_TYPE GARN_TYPE GARN_TYPE GARN_TYPE COURT_NAME COURT_DOC_ID COURT_DOC_ID2 DOC_RCVD_DT DOC_RCVD_HR DOC_RCVD_MN RESP_REQ_DT RESP_REQ_HR RESP_REQ_MN COUNTRY ADDRESS1 ADDRESS2 ADDRESS3 ADDRESS4 CITY NUM1 NUM2 HOUSE_TYPE ADDR_FIELD1 ADDR_FIELD2 ADDR_FIELD3 COUNTY STATE POSTAL GEO_CODE IN_CITY_LIMIT CONTACT_NAME PHONE GARN_PRIORITY CMPNY_INCL_DE PAYEE_INCL_DE GARN_LIMIT_AMT GARN_LIMIT_BAL
TYPE Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Date Nbr Char Date Nbr Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Nbr Char Char Nbr Nbr
START POS 1 9 18 29 32 38 39 40 41 42 43 44 39 39 39 39 39 39 39 39 39 39 40 100 125 150 160 162 164 174 176 178 181 236 291 346 401 431 437 441 443 445 449 453 483 489 501 512 513 563 587 590 591 592 601
RAW LENG 8 9 11 3 6 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 60 25 25 10 2 2 10 2 2 3 55 55 55 55 30 6 4 2 2 4 4 30 6 12 11 1 50 24 3 1 1 9 9
MASK
FORMAT 8 Upper 9 11 Upper 3 Upper 6 Upper 1 Upper 1 Value 1 A 1 C 1 J 1 R 1 S 1 Upper 1 Value 1 A 1 B 1 C 1 D 1 L 1 S 1 T 1 W 60 Mixed 25 Mixed 25 Mixed 10 2 2 10 2 2 3 Upper 55 Mixed 55 Mixed 55 Mixed 55 Mixed 30 Mixed 6 Mixed 4 Mixed 2 Upper 2 Upper 4 Upper 4 Upper 30 Mixed 6 Upper 12 Custom 11 Upper 1 Upper 50 Mixed 24 Custom 3 1 Upper 1 Upper 6.2 6.2
DESCRIPTION KEY Value: GARNSPEC Social Security Number EmplID K Company K Garnish ID K Garnish Status Description Garnishment Request Approved Garnishment Deduct Completed Garnishment Request Rejected Garnishment Request Received Garnishment Deduct Suspended Garnish Type Description Wage Assignment Chapter 13 Bankruptcy Child Support Dependent Support Tax Levy Spousal Support Student Loan Repayment Writ of Garnishment Court Name Issuing Order Court Document ID Court Secondary Document ID Document Recevied Date - YYYYMMDD Document Received Hour Document Received Minute Response Required By Date - YYYYMMDD Response Required by Hour Response Required By Minute Country Address Line 1 Address Line 2 Address Line 3 Address Line 4 City Number 1 Number 2 House Type Address Field 1 Address Field 2 Address Field 3 County State Postal Code Tax Vendor Geographical Code In City Limit Contact Name Telephone Garnish Priority Include Company Fee Within DE Include Payee Fee Within DE Garnish Limit Amount Garnish Limit Balance
NO CHANGES FOR 9.0
EMPLOYEE SETUP
GARN_SPEC
REVISED: 02/06/2004
FIELD NAME GARN_MTH_LIM_AMT CMPNY_MTH_LIM_AMT PAYEE_MTH_LIM_AMT START_DT STOP_DT AUTO_CALC_STOP AUT_CALC_STOP_DAYS GARN_DED_SCHED GARN_DED_SCHED GARN_DED_SCHED GARN_DED_SCHED GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_CALC GARN_DED_PCT GARN_DED_AMT GARN_VAR_FREQUENCY CMPNY_FEE_PCT CMPNY_FEE_AMT PAYEE_FEE_PCT PAYEE_FEE_AMT GARN_REMARKS PRORATE_INEFF_SW STATE_GARN_PRORATE GARN_PRORATE_RL_ID GARN_SUPPORT_TYPE GARN_SUPPORT_TYPE GARN_SUPPORT_TYPE GARN_SUPPORT_TYPE PRORATE_OVRD_PCT PRORATE_OVRD_AMT DEDCD SETID VENDOR_ID ADDRESS_SEQ_NUM PAY_MODE AP_PAYMENT_DT_TYPE AP_PAYMENT_DT_TYPE AP_PAYMENT_DT_TYPE AP_PAYMENT_DT_TYPE SEPARATE_AP_PAYMNT GARN_PAYEE_NAME FILLER
TYPE Nbr Nbr Nbr Date Date Char Nbr Char Char Char Char Char Char Char Char Char Char Char Char Char Nbr Nbr Char Nbr Nbr Nbr Nbr Char Char Char Char Char Char Char Char Nbr Nbr Char Char Char Nbr Char Char Char Char Char Char Char Char
START POS RAW LENG MASK FORMAT 610 9 6.2 619 9 6.2 628 9 6.2 637 10 10 647 10 10 657 1 1 Upper 658 3 3 661 1 1 Upper 662 1 1 Value 663 1 1 A 664 1 1 S 662 1 1 Upper 662 1 1 Value 662 1 1 G 662 1 1 H 662 1 1 M 662 1 1 P 662 1 1 R 662 1 1 S 662 1 1 T 663 6 3.2 669 9 6.2 678 1 1 Upper 679 6 3.2 685 9 6.2 694 6 3.2 700 9 6.2 709 254 254 963 1 1 Upper 964 6 6 Upper 970 6 6 Upper 976 1 1 Upper 977 1 1 Value 978 1 1 A 979 1 1 C 977 6 3.2 983 9 6.2 992 6 6 Upper 998 5 5 Upper 1003 10 10 Upper 1013 3 3 1016 1 1 Upper 1017 1 1 Upper 1018 1 1 Value 1019 1 1 C 1020 1 1 P 1018 1 1 Upper 1019 30 30 Mixed 1049 295 Total Length 1375
DESCRIPTION Garnish Monthly Limit Amount Company Fee Monthly Limit Amt Payee Fee Monthly Limit Amount Start Date - YYYYMMDD Stop Date - YYYYMMDD Auto Calc Stop Date Auto Calc Stop Days Garnish Deduction Schedule Description Deduct on All Payrolls Deduct by Schedule Garnish Deduction Calc Routine Description Greater of %DE or Amount Greater of %Gross or Amount Maximum Allowed % DE + Amount % Gross + Amount No exempt; %DE + Amt No exempt; % of Gross Garnish Deduct DE Percent Garnish Flat Deduction Amount Garnish Variable Frequency Company's Voucher Fee Percent Company's Voucher Fee Amount Payee's Voucher Fee Percent Payee's Voucher Fee Amount Garnish Remarks Garn proration-in-effect sw Proration Rule State Garnishment proration rule ID Garnishment Support Type Description Arrears Order Current Order Garn prorate override percent Garn prorate override amount Deduction Code SetID Vendor ID Address Sequence Number Pay Mode AP Payment Date Type Description Check Date Pay Period End Date Separate AP Payment Garnishment Payee Name Spaces
KEY
NO CHANGES FOR 9.0
EMPLOYEE SETUP PEOPLESOFT RAW LENG MASK FORMAT 1 8 8 Upper 9 9 9
GENL_DEDUCTION LEGACY DESCRIPTION Value: GENLDED Social Security Number TABLE FIELD TYPE LEN CONVERSION RULE
REVISED: 08/23/2004
TYPE RECORD_NAME SSN
TYPE Char Char
START POS
ISSUES / Comments
EMPLID
Char
18
11
11 Upper
EmplID
APSPS
PSXX-R-SSN
NUM
PS Load program will look up SSN on PERS_NID to obtain EmplID.
COMPANY
Char
29
3 Upper
Company
APSPS
PSXX-C-AGCY NUM
Agency = Company furnished from Extract Load. Extract Load is NOT to include the following AORG codes: SAST (State Annuity), SROP (OPERS Retirement), SROL (OLERS Retirement), SRTD (Teachers Retirement), SRTR (Teachers Retirement), SRTE (Teachers Retirement), SRTS (Teachers Retirement), SRTX (Teachers Retirement), SRWL (Wildlife Retirement), OSBI (OSBI's Police Pension).
(1) If multiple general deductions, PS Load will create an additional row for each deduction. PS Load will use agency # to assign company code. PS Load will validate # by comparing to Company Table.
DEDCD
Char
32
6 Upper
Deduction Code Effective Date YYYYMMDD Deduction Calculation Routine
APSPSRD PSRD-C-AORG ALPHA
EFFDT DED_CALC DED_CALC
Date Char Value A
38 46
8 1 Description Flat Amount
8 1 Upper
APSPSRD PSRD-D-BEGIN-CYMD NUM
Also, do not include SoonerChoice AORG codes ("C Extract Load will furnish ME", "C DA", "C VI", "F HE", "F correct PS Deduction Code. PS Load will convert to DDMON-YYYY format from Extract Load. PS Load will default to 'A'
DEDUCTION_END_DT DED_ADDL_AMT DED_RATE_PCT
Date Nbr Nbr
47 55 66
8 11 8
8 8.2 4.3
Deduction End Date YYYYMMDD Deduction Flat/Addl Amount Deduction Rate/Percent
APSPSRD PSRD-D-END-CYMD NUM APSPSRD PSRD-A-DED
Extract Load will read the date and furnish the date being the First of the next month for employees on Monthly Pay Cycles, exluding Agency 830. If Agency 830, this date will be the 16th of the next month. If a BiWeekly pay cycle, the date will be the begin date of their next pay cycle.. Extract Load will furnish. PS Load will default to '0'
Extract Load will only give the end date if it is less than the current date. If the end date is all nines, or is an invalid date Extract Load will furnish a Blank field filled with spaces. PS Load will then default this field to NULL. If Extract Load furnishes a date PS Load will format it to dd-mon-yyyy.
Sign NUM 8
GOAL_AMT
Sign
74
12
9.2
Goal Amount
PS Load will default to '0'
Goal Amount field is the total amount that needs to be paid off before the deduction can be stopped. (Ex: Paying off a company loan, etc.)
EMPLOYEE SETUP PEOPLESOFT RAW LENG MASK
GENL_DEDUCTION LEGACY FORMAT DESCRIPTION TABLE FIELD TYPE LEN CONVERSION RULE
REVISED: 08/23/2004
TYPE
TYPE
START POS
ISSUES / Comments This field works in conjunctions with the above field. It is the amount that has been paid so far. When this field is equal to above field, Goal Amount, the deduction automatically stops.
GOAL_BAL LOAN_INT_PCT BAS_TAXABLE_BEN DED_STOPPED LAST_ACTION
Sign Nbr Char Char Char Value C
86 98 104 105 106
12 6 1 1 1 Description System
9.2 2.3 1 Upper 1 Upper 1 Upper
Current Goal Balance Loan Interest Percent Ben Admin Taxable Ben (Canada) Ded. stopped by Self Serv User Last Action
PS Load will default to '0' PS Load will default to '0' PS Load will default to 'N' PS Load will default to 'N' PS Load will default to 'C'
LAST_UPDATE_DATE PROCESS_DEDN GVT_DED_DIST_CD GVT_PYMNT_METHOD GVT_CHK_NAME GVT_ADDRESS1 GVT_ADDRESS2 GVT_ADDRESS_CITY GVT_ADDRESS_STATE GVT_ADDRESS_ZIP GVT_ADDRESS_CNTRY BANK_CD ACCOUNT_NUM ACCOUNT_TYPE GVT_PAYEE_ID_NO GVT_PAYEE_NAME GVT_ALLOT_PB FILLER
Date Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char
107 115 116 126 127 152 187 222 238 244 254 257 268 285 286 295 317 318 Total Length
8 1 10 1 25 35 35 16 6 10 3 11 17 1 9 22 1 1020 1337
8 1 Upper 10 Upper 1 Upper 25 Upper 35 Mixed 35 Mixed 16 Mixed 6 Upper 10 Upper 3 Upper 11 Custom 17 Upper 1 Upper 9 Upper 22 Upper 1 Upper
Date of last update YYYYMMDD Process Deduction Deduction Distribution Cd Payment Method GVT Check Payee Name GVT Address Line 1 GVT Address Line 2 GVT Address City GVT Address State GVT Address Zip GVT Address Country Bank ID Account Number Account Type GVT EFT Payee ID Number GVT EFT Account Holder GVT Allotment Pushbutton Spaces
Extract Date
PS Load will format to dd_mon_yyyy date. PS Load will default to 'Y'. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank. PS Load will default to Blank.
This is the date the data was extracted from the Legacy System and furnished by Extract Load..
EMPLOYEE SETUP
GENL_DEDUCTION
REVISED: 08/23/2004
NO CHANGES FOR 9.0
EMPLOYEE SETUP
GENL_DEDUCTION
REVISED: 08/23/2004
NO CHANGES FOR 9.0
Gen Deduction Code Crosswalk
Peoplesoft System Description Blue Cross/Blue Shield Colonial Life Insurance American Family Life Insurance American Public Life Insurance Conseco Health Ins. Company Mega Life & Health Ins. Co. American Fidelity Assurance Co Citizen's Insurance Company Aegon USA Occidental Life Ins. (AM LIB) Paramount Life Ins Prepaid Legal Leader's Life Ins. CO American Fidelity Assu.-Cancer American General (Universal Li Trustmark Insurance Company American Heritage Life Insurance National Accident Insurance 5 Star Life Insurance Company Central States Health and Life Company of Omaha Bankers Life - OESC Taxable ROC-Group America - Life Ins OPERS Catch-Up Retirement Travelers (OESC Retirement) Oklahoma Employees CR Union Credit Union One of Oklahoma CSH Credit Union DPS Credit Union Okla Educators Credit Union OK Hlth SVC Fed Credit Union Tulsa Teachers Credit Union OHS Credit Union Municipal Employees Cr Union University & Comm Fed Cr Union OU Employees Federal Cr Union Red River Federal Credit Union Mayes County Federal Cr Union Texoma Educators Fed Cr Union F.O.P. Credit Union, Tulsa Deduction Code AI01 AI02 AI03 AI05 AI06 AI07 AI09 AI10 AI14 AI20 AI22 AI24 AI29 AI35 AI36 AI39 AI40 AI41 AI42 AI43 AIBA AIGA ARCU ARES AU02 AU04 AU05 AU06 AU08 AU09 AU11 AU15 AU16 AU17 AU18 AU19 AU20 AU21 AU22
Legacy System
Object Code AI01 AI02 AI03 AI05 AI06 AI07 AI09 AI10 AI14 AI20 AI22 AI24 AI29 AI35 AI36 AI39 AI40 AI41 AI42 AI43 AIBA AIGA ARCU ARES AU02 AU04 AU05 AU06 AU08 AU09 AU11 AU15 AU16 AU17 AU18 AU19 AU20 AU21 AU22
143863489.xls.ms_office
Page 32
Peoplesoft System Description East Central Teacher CU Allegiance Credit Union Bankers Life - OESC Flexible Regents For OK College-CAFE Okla County DC Other Cafe Okla Troopers Assoc CWA/Okla State Workers Union TIAA-CREFF College Fund Oklahoma Magazine Okla Public Employees Assn Retirement Tax Def - OSBI Teachers Ret Tax-Def Install Teachers Ret Employee(ROC&STL) MISC/Retirement Deferred Annuity-Am. Fidelity Assur. Co Annuity-Capitol Guardian Trust Annuity-Equitable Life Assur. Annuity-American Express Fin Annuity - Franklin Templeton Annuity - Metropolitan Life Ins Annuity (Education) Annuity - Edward Jones Co. Annuity-Security Benefit Life Annuity - Teachers Retirement Annuity-Teachrs Ins&Annu. Asoc Annuity-Variable Annu Life Ins Annuity-Waddell/Reed Fin. Serv Annuity - Great American Life Annuity-Minnesota Mutual Annuity-Northern Life Ins. Co. Annuity-AAL Capital Mgmt Corp Annuity - Fiduciary Trust Co. Annuity - USAA Life Ins. Co. Annuity - Putman Investor Serv Ameritas Finance Services Annuity - John Hancock Insurance Annuity - Trans American Life MFS Service Center Inc. Deduction Code AU23 AU24 E BA E IN E OC MI01 MI02 MI04 MIOK OPEA ORBI ORTI ORTR ORTT SAE1 SAE4 SAE6 SAE9 SAEB SAEC SAED SAEF SAEH SAEI SAEJ SAEL SAEM SAEO SAEP SAER SAES SAEV SAEZ SAF2 SAF4 SAFA SAFB SAFI
Legacy System
Object Code AU23 AU24 E BA E IN E OC MI01 MI02 MI04 MIOK OPEA ORBI ORTI ORTR ORTT SAE1 SAE4 SAE6 SAE9 SAEB SAEC SAED SAEF SAEH SAEI SAEJ SAEL SAEM SAEO SAEP SAER SAES SAEV SAEZ SAF2 SAF4 SAFA SAFB SAFI
Page 33
Peoplesoft System Description Goldman SACHS Funds ANNU - The Kaufmann Fund, Inc. Annuity - Pershing State Annuity- Spec Term/Long Charitable Contributions Deduction Code SAFJ SAFK SAFL SASS SC01
Legacy System
Object Code SAFJ SAFK SAFL SASS SC01
This crosswalk is used as a working document for reference purposes only. The General Deduction Codes have been named the same as on Legacy System.
Page 34
\\vboxsrv\conversion_tmp\scratch_6\143863489.xls.ms_office Legacy F HE HEA010 HEA010 "A" "B", "C", "D", "E", "F" "X" F HE HEA070 HEA070 "A" "B", "C", "D", "E", "F" "X" F HE HEA072 HEA072 "A" "B", "C", "D", "E", "F" "X" F HE HEA090 HEA090 "A" "B", "C", "D", "E", "F" "X" F HE HEA092 HEA092 "A" "B", "C", "D", "E", "F" "X" F HE HEA200 HEA200 "A" "B", "C", "D", "E", "F" "X" F DE "A" "B", "C", "D", "E", "F" "X" 0527O 0543O 0518O 0536O 0510O 0535O 0516O 0554O 0517O 0556O 0513O 0550O PeopleSoft Legacy SIHE "A" "B", "C", "D", "E", "F" "X" SIHE "A" "B", "C", "D", "E", "F" "X" SIHE "A" "B", "C", "D", "E", "F" "X" SIHE "A" "B", "C", "D", "E", "F" "X" SIHE "A" "B", "C", "D", "E", "F" "X" SIHE "A" "B", "C", "D", "E", "F" "X" SIDE "A" "B", "C", "D", "E", "F" "X" 0627O 0643O 0618O 0636O 0610O 0635O 0616O 0654O 0617O 0656O 0613O 0650O PeopleSoft
DEN010
0560O
0660O
DEN030
F DE "A" "B", "C", "D", "E", "F" "X"
0561O
SIDE "A" "B", "C", "D", "E", "F" "X"
0661O
DIS010
F DI "A", "X" F LI "A". "X" C VI Single FAMILYX "A", "B", "C", "D", "E", "F" "X" "A", "B", "C", "D", "E", "F" "X"
0570O
SIDI "A" "X" SILI "A", "X"
0670O
LIF010
0575O
0675O
0223O 0223O
V040
0224O
SNG-TX FAM-TXX "A", "B", "C", "D", "E", "F" "X" "A", "B", "C", "D", "E", "F" "X"
0423O 0423O
0424O
V050
0225O
0425O
Gen Deduct Empl Adj Crosswalk
Page 35 of 74
\\vboxsrv\conversion_tmp\scratch_6\143863489.xls.ms_office "A", "B", "C", "D", "E", "F" "X" "A", "B", "C", "D", "E", "F" "X" SISL If there is an amount in the deduction field and the taxable field we need to subract out the taxable amount to arrive at the pretax amount "A", "B", "C", "D", "E", "F" "X" "A", "B", "C", "D", "E", "F" "X"
V060
0226O
0426O
V070
0227O
0427O
Deduction Amount
0585O
Taxable Amount
0685O
C ME
0221O
C DA SIDP DEP010 DEP012
0222O
"J" or "X" "J" or "X"
0690O 0691O
Gen Deduct Empl Adj Crosswalk
Page 36 of 74
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
FIELD NAME RECORD_NAME SSN EMPLID EMPL_RCD EFFDT EFFSEQ DEPTID JOBCODE POSITION_NBR POSITION_OVERRIDE POSN_CHANGE_RECORD EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS EMPL_STATUS ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION ACTION
TYPE Char Char Char Nbr Date Nbr Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char
START POS 1 9 18 29 32 42 45 55 61 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 72 72 72 72 72 72 72 72 72 72 72 72 72 72 72 72 72 72 72 72
RAW LENGTH 8 9 11 3 10 3 10 6 8 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
MASK 8 9 11 3 10 3 10 6 8 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
FORMAT Upper Upper
Upper Upper Upper Upper Upper Upper Value A D L P Q R S T U V W X Upper Value ADD ADL DEM DET DTA EDT HIR JRC LOA PAY PLA POS PRB PRC PRO REC REH RET
DESCRIPTION Value: JOBDATA Social Security Number EmplID Empl Rcd Nbr Effective Date - YYYYMMDD Effective Sequence Department Job Code Position Number Override Position Data Position Management Record Employee Status Description Active Deceased Leave of Absence Leave With Pay Retired With Pay Retired Suspended Terminated Terminated With Pay Terminated Pension Pay Out Short Work Break Retired-Pension Administration Action Description Add Non-Employee Additional Job Demotion Detail Data Change End of Detail Hire Job Reclassification Leave of Absence Pay Rate Change Paid Leave of Absence Position Change Probation Completion of Probation Promotion Recall from Suspension/Layoff Rehire Retirement
KEY
K K K K K K K
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
FIELD NAME ACTION ACTION ACTION ACTION ACTION_DT ACTION_REASON LOCATION TAX_LOCATION_CD JOB_ENTRY_DT DEPT_ENTRY_DT POSITION_ENTRY_DT SHIFT SHIFT SHIFT SHIFT SHIFT SHIFT SHIFT SHIFT REG_TEMP REG_TEMP REG_TEMP REG_TEMP REG_TEMP REG_TEMP REG_TEMP FULL_PART_TIME FULL_PART_TIME FULL_PART_TIME FULL_PART_TIME COMPANY PAYGROUP BAS_GROUP_ID ELIG_CONFIG1 ELIG_CONFIG2 ELIG_CONFIG3 ELIG_CONFIG4 ELIG_CONFIG5 ELIG_CONFIG6 ELIG_CONFIG7 ELIG_CONFIG8 ELIG_CONFIG9 BEN_STATUS BEN_STATUS BEN_STATUS
TYPE Char Char Char Char Date Char Char Char Date Date Date Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char
START POS 72 72 72 72 75 85 88 98 108 118 128 138 139 140 141 142 143 144 145 139 139 139 139 139 139 139 140 140 140 140 141 144 147 150 160 170 180 190 200 210 220 230 240 244 248
RAW LENGTH 3 3 3 3 10 3 10 10 10 10 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3 3 10 10 10 10 10 10 10 10 10 4 4 4
MASK 3 3 3 3 10 3 10 10 10 10 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3 3 10 10 10 10 10 10 10 10 10 4 4 4
FORMAT RFL SUS TER XFR Upper Upper Upper
Upper Value 1 2 3 C N R Upper Value E P R S T Upper Value F P Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Value A
DESCRIPTION Return from Leave Suspension Termination Transfer Action Date - YYYYMMDD Reason Code Location Code Tax Location Code Job Entry Date - YYYYMMDD Department Entry Date - YYYYMMDD Position Entry Date - YYYYMMDD Regular Shift Description 1 2 3 Compressed Not Applicable Rotating Regular/Temporary Description Seaonal Employee Projects Regular Student Employee Temporary Full/Part Time Description Full-Time Part-Time Company Pay Group BAS Group ID Eligibility Config Field 1 Eligibility Config Field 2 Eligibility Config Field 3 Eligibility Config Field 4 Eligibility Config Field 5 Eligibility Config Field 6 Eligibility Config Field 7 Eligibility Config Field 8 Eligibility Config Field 9 Benefits Employee Status Description Active
KEY
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
FIELD NAME BEN_STATUS BEN_STATUS BEN_STATUS BEN_STATUS BEN_STATUS BEN_STATUS BEN_STATUS BEN_STATUS BAS_ACTION COBRA_ACTION EMPL_TYPE HOLIDAY_SCHEDULE STD_HOURS STD_HRS_FREQUENCY OFFICER_CD OFFICER_CD OFFICER_CD OFFICER_CD OFFICER_CD OFFICER_CD EMPL_CLASS SAL_ADMIN_PLAN GRADE GRADE_ENTRY_DT STEP STEP_ENTRY_DT GL_PAY_TYPE
TYPE Char Char Char Char Char Char Char Char Char Char Char Char Nbr Char Char Char Char Char Char Char Char Char Char Date Nbr Date Char
START POS 252 256 260 264 268 272 276 280 244 247 250 251 257 264 269 270 271 272 273 274 270 273 277 280 290 292 302
RAW LENGTH 4 4 4 4 4 4 4 4 3 3 1 6 7 5 1 1 1 1 1 1 3 4 3 10 2 10 6
MASK 4 4 4 4 4 4 4 4 3 3 1 6 4.2 5 1 1 1 1 1 1 3 4 3 10 2 10 6
FORMAT D L P Q R S T U Upper Upper Upper Upper Upper Upper Value E J L N Upper Upper Upper
Upper
DESCRIPTION Deceased Leave of Absence Leave With Benefits Retired With Benefits Retired Suspended Terminated Terminated With Benefits Benefits Administration Action COBRA Action Employee Type Holiday Schedule Standard Hours Standard Work Period Officer Code Description Elected Official Judicial Legislator None Employee Classification Salary Administration Plan Salary Grade Grade Entry Date - YYYYMMDD Step Step Entry Date - YYYYMMDD General Ledger Pay Type
KEY
ACCT_CD EARNS_DIST_TYPE EARNS_DIST_TYPE EARNS_DIST_TYPE EARNS_DIST_TYPE EARNS_DIST_TYPE EARNS_DIST_TYPE SALARY_MATRIX_CD RATING_SCALE REVIEW_RATING REVIEW_DT COMP_FREQUENCY COMPRATE CHANGE_AMT CHANGE_PCT
Char Char Char Char Char Char Char Char Char Char Date Char Nbr Sign Sign
308 333 334 335 336 337 338 334 339 343 344 354 359 378 398
25 1 1 1 1 1 1 5 4 1 10 5 19 20 8
25 1 1 1 1 1 1 5 4 1 10 5 12.6 12.63.3-
Upper Upper Value A H N P Upper Upper Upper Upper
Account Code Earnings Distribution Type Description By Amount By Hours None By Percent Salary Matrix Code Rating Scale Review Rating Review Date - YYYYMMDD Compensation Frequency Compensation Rate Change Amount Change Percent
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
FIELD NAME ANNUAL_RT MONTHLY_RT DAILY_RT HOURLY_RT ANNL_BENEF_BASE_RT SHIFT_RT SHIFT_FACTOR CURRENCY_CD BUSINESS_UNIT SETID_DEPT SETID_JOBCODE SETID_LOCATION SETID_SALARY REG_REGION DIRECTLY_TIPPED DIRECTLY_TIPPED DIRECTLY_TIPPED DIRECTLY_TIPPED DIRECTLY_TIPPED FLSA_STATUS EEO_CLASS FUNCTION_CD TARIFF_GER TARIFF_AREA_GER PERFORM_GROUP_GER LABOR_TYPE_GER SPK_COMM_ID_GER WRKS_CNCL_MEM_GER HOURLY_RT_FRA ACCDNT_CD_FRA VALUE_1_FRA VALUE_2_FRA VALUE_3_FRA VALUE_4_FRA VALUE_5_FRA CTG_RATE PAID_HOURS PAID_FTE PAID_HRS_FREQUENCY
TYPE Nbr Nbr Nbr Nbr Nbr Nbr Nbr Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Nbr Nbr Nbr Char
START POS 406 425 444 463 482 501 520 525 528 533 538 543 548 553 558 559 560 561 562 559 560 561 563 565 568 570 571 580 583 586 587 592 597 602 607 612 615 622 626
RAW LENGTH 19 19 19 19 19 19 5 3 5 5 5 5 5 5 1 1 1 1 1 1 1 2 2 3 2 1 9 3 3 1 5 5 5 5 5 3 7 4 5
MASK 15.3 15.3 15.3 12.6 15.3 12.6 1.3 3 5 5 5 5 5 5 1 1 1 1 1 1 1 2 2 3 2 1 9 3 3 1 5 5 5 5 5 3 4.2 1.2 5
FORMAT
Upper Upper Upper Upper Upper Upper Upper Upper Value D I N Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Mixed Mixed Mixed Mixed Mixed
Upper
DESCRIPTION Annual Rate Monthly Rate Daily Rate Hourly Rate Annual Benefits Base Rate Shift Differential Rate Shift Differential Factor Currency Code Business Unit Department SetID Job Code SetID Location SetID Salary SetID Regulatory Region Tipped Description Directly Tipped Indirectly Tipped Not Tipped FLSA Status EEO Classification Function Code Tariff Tariff Area Performance Group Labor Type Spokesmen Committee ID Works Council Member Hours Type Work Accident Type Code Value 1 Value 2 Value 3 Value 4 Value 5 Category Rate Paid Hours Paid FTE Paid Work Period
KEY
PER_ORG
Char
631
Upper
Organizational Relationship
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
FIELD NAME
TYPE
START POS
RAW LENGTH
MASK
FORMAT
DESCRIPTION
KEY
HR_STATUS SUPV_LVL_ID SETID_SUPV_LVL POI_TYPE AUTO_END_FLG HIRE_DT LAST_HIRE_DT TERMINATION_DT ASGN_START_DT LST_ASGN_START_DT ASGN_END_DT LDW_OVR LAST_DATE_WORKED EXPECTED_RETURN_DT EXPECTED_END_DATE LASTUPDDTTM LASTUPDOPRID FILLER GVT_EFFDT GVT_EFFDT_PROPOSED GVT_TRANS_NBR GVT_TRANS_NBR_SEQ GVT_WIP_STATUS GVT_STATUS_TYPE GVT_NOA_CODE GVT_LEG_AUTH_1 GVT_PAR_AUTH_D1 GVT_PAR_AUTH_D1_2 GVT_LEG_AUTH_2 GVT_PAR_AUTH_D2 GVT_PAR_AUTH_D2_2 GVT_PAR_NTE_DATE GVT_WORK_SCHED GVT_SUB_AGENCY GVT_ELIG_FEHB GVT_FEHB_DT GVT_PAY_RATE_DETER GVT_STEP GVT_RTND_PAY_PLAN GVT_RTND_SAL_PLAN
Char Char Char Char Char Date Date Date Date Date Date Char Date Date Date DTTM Char Char Date Date Nbr Nbr Char Char Char Char Char Char Char Char Char Date Char Char Char Date Char Char Char Char
634 635 643 648 653 654 664 674 684 694 704 714 715 725 735 745 771 801 631 641 651 652 653 656 659 662 665 690 715 718 743 768 778 779 781 784 794 795 797 799
1 8 5 5 1 10 10 10 10 10 10 1 10 10 10 26 30 278 10 10 1 1 3 3 3 3 25 25 3 25 25 10 1 2 3 10 1 2 2 4
1 8 5 5 1 10 10 10 10 10 10 1 10 10 10 26 30 278 10 10 1 1 3 3 3 3 25 25 3 25 25 10 1 2 3 10 1 2 2 4
Status Supervisor Level Supervisor Level Setid Person of Interest Type Auto End Job First Start Date Last Start Date Termination Date First Assignment Start Last Assignment Start Date Last Assignment Date Override Last Date Worked Last Date Worked Expected Return Date Expected Job End Date Last Update Date/Time Last Update Userid Filler Effective Date - YYYYMMDD Proposed Effective Date - YYYYMMDD Transaction # Sequence Work-in-Progress Status Status Type Nature of Action Code Legal Authority (1) Authority 1 Descr - Part 1 Authority 1 Descr - Part 2 Legal Authority (2) Authority 2 Descr - Part 1 Authority 2 Descr - Part 2 Not To Exceed Date - YYYYMMDD Work Schedule Sub-Agency Eligible for FEHB FEHB Eligibility Date - YYYYMMDD Pay Rate Determinant US Federal Step Retained Pay Plan Retained Pay Table
Upper Upper Upper Upper Mixed Mixed Upper Mixed Mixed Upper Upper Upper Upper Upper Upper Upper
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
FIELD NAME GVT_RTND_GRADE GVT_RTND_STEP GVT_RTND_GVT_STEP GVT_PAY_BASIS GVT_COMPRATE GVT_LOCALITY_ADJ GVT_BIWEEKLY_RT GVT_DAILY_RT GVT_HRLY_RT_NO_LOC GVT_DLY_RT_NO_LOC GVT_BW_RT_NO_LOC GVT_MNLY_RT_NO_LOC GVT_ANNL_RT_NO_LOC GVT_XFER_FROM_AGCY GVT_XFER_TO_AGCY GVT_RETIRE_PLAN GVT_ANN_IND GVT_FEGLI GVT_FEGLI_LIVING GVT_LIVING_AMT GVT_ANNUITY_OFFSET GVT_CSRS_FROZN_SVC GVT_PREV_RET_COVRG GVT_FERS_COVERAGE GVT_TYPE_OF_APPT GVT_POI GVT_POSN_OCCUPIED GVT_CONT_EMPLID GVT_ROUTE_NEXT GVT_CHANGE_FLAG GVT_TSP_UPD_IND GVT_PI_UPD_IND GVT_SF52_NBR GVT_S113G_CEILING GVT_LEO_POSITION GVT_ANNUIT_COM_DT GVT_BASIC_LIFE_RED GVT_DED_PRORT_DT GVT_FEGLI_BASC_PCT GVT_FEGLI_OPT_PCT GVT_FEHB_PCT GVT_RETRO_FLAG GVT_RETRO_DED_FLAG GVT_RETRO_JOB_FLAG GVT_RETRO_BSE_FLAG
TYPE Char Nbr Char Char Nbr Nbr Nbr Nbr Nbr Nbr Nbr Nbr Nbr Char Char Char Char Char Char Nbr Nbr Char Char Char Char Char Char Char Char Char Char Char Char Char Char Date Char Date Nbr Nbr Nbr Char Char Char Char
START POS 803 806 808 810 812 831 839 849 859 878 888 898 917 936 938 940 941 942 944 945 953 961 965 966 967 969 973 974 985 996 997 998 999 1009 1010 1011 1021 1023 1033 1041 1049 1057 1058 1059 1060
RAW LENGTH 3 2 2 2 19 8 10 10 19 10 10 19 19 2 2 1 1 2 1 8 8 4 1 1 2 4 1 11 11 1 1 1 10 1 1 10 2 10 8 8 8 1 1 1 1
MASK 3 2 2 2 12.6 5.2 7.2 7.2 12.6 7.2 7.2 15.3 15.3 2 2 1 1 2 1 8 8 4 1 1 2 4 1 11 11 1 1 1 10 1 1 10 2 10 1.6 1.6 1.6 1 1 1 1
FORMAT Upper Upper Upper
Upper Upper Upper Upper Upper Upper
Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper
Upper Upper Upper Upper
DESCRIPTION Retained Grade Retained Step Retained US Federal Step Pay Basis Base Pay Locality Adjustment Biweekly Rate Daily Rate Hourly Rate with out Location Daily Rate No Locality No Locality Biweekly Rate No Locality Monthly Rate No Locality Annual Rate Transferred From Agency Transferred To Agency Retirement Plan Annuitant Indicator FEGLI Code FEGLI Living Benefits Living Benefit Coverage Amount CSRS Annuity Offset Amount CSRS Frozen Service Previous Retirement Coverage FERS Coverage Type of Appointment Personnel Office ID Position Occupied Contact Emplid Route to Next Change Flag TSP Status pi upd ind SF-52 Request Number SF-113G Ceiling LEO/Fire Position Annuity Commencement Date - YYYYMMDD Post 65 Basic Life Reduction 4 Day Date - YYYYMMDD FEGLI Basic Percent FEGLI Optional Percent FEHB % Retro Pay Flag Retro Ded Flag Retro Job Flag Retro Base Flag
KEY
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
FIELD NAME GVT_OTH_PAY_CHG GVT_DETL_POSN_NBR ANNL_BEN_BASE_OVRD BENEFIT_PROGRAM UPDATE_PAYROLL GVT_PAY_PLAN GVT_PAY_FLAG GVT_NID_CHANGE UNION_FULL_PART UNION_POS MATRICULA_NBR SOC_SEC_RISK_CODE UNION_FEE_AMOUNT UNION_FEE_START_DT UNION_FEE_END_DT EXEMPT_JOB_LBR EXEMPT_HOURS_MONTH WRKS_CNCL_FUNCTION INTERCTR_WRKS_CNCL CURRENCY_CD1 PAY_UNION_FEE UNION_CD BARG_UNIT UNION_SENIORITY_DT ENTRY_DATE LABOR_AGREEMENT EMPL_CTG EMPL_CTG_L1 EMPL_CTG_L2 SETID_LBR_AGRMNT GP_PAYGROUP GP_DFLT_ELIG_GRP GP_ELIG_GRP GP_DFLT_CURRTTYP CUR_RT_TYPE GP_DFLT_EXRTDT GP_ASOF_DT_EXG_RT ADDS_TO_FTE_ACTUAL CLASS_INDC CLASS_INDC CLASS_INDC CLASS_INDC CLASS_INDC CLASS_INDC ENCUMB_OVERRIDE
TYPE Char Char Char Char Char Char Char Char Char Char Nbr Char Nbr Date Date Char Nbr Char Char Char Char Char Char Date Date Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char
START POS 1061 1062 1070 1071 1074 1075 1077 1078 1079 1080 1081 1086 1089 1098 1108 1118 1119 1122 1123 1124 1127 1128 1131 1135 1145 1155 1161 1167 1173 1179 1184 1194 1195 1205 1206 1211 1212 1213 1214 1215 1216 1217 1218 1219 1215
RAW LENGTH 1 8 1 3 1 2 1 1 1 1 5 3 9 10 10 1 3 1 1 3 1 3 4 10 10 6 6 6 6 5 10 1 10 1 5 1 1 1 1 1 1 1 1 1 1
MASK 1 8 1 3 1 2 1 1 1 1 5 3 6.2 10 10 1 3 1 1 3 1 3 4 10 10 6 6 6 6 5 10 1 10 1 5 1 1 1 1 1 1 1 1 1 1
FORMAT Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper
Upper Upper Upper Upper Upper Upper Upper
Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Value B C T U Upper
DESCRIPTION Other Pay Change Flag GVT Detail Position Number Annl Benefit Base Rt Override Benefit Program Update Payroll Flags Pay Plan GVT_PAY_FLAG GVT_NID_CHANGE Union Participation Union Position Matricula Number Social Security Risk Code Union Fee Amount Union Fee Start Date - YYYYMMDD Union Fee End Date - YYYYMMDD Exempted Exempted Hours per Month Works Council Function InterCtr.Works Cnil Function Currency Code Pay Union Fee Union Code Bargaining Unit Union Seniority Date - YYYYMMDD Date Entered - YYYYMMDD Labor Agreement Employee Category Employee Subcategory Employee Subcategory 2 Labor Agreement SetID Pay Group Use Pay Group Value Eligibility Group Use Pay Group Value Exchange Rate Type Use Pay Group Value Use Rate As Of Adds to FTE Actual Count Classified/Unclassified Indc Description All Classified Temporary Unclassified Encumbrance Override
KEY
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
FIELD NAME FICA_STATUS_EE FICA_STATUS_EE FICA_STATUS_EE FICA_STATUS_EE FICA_STATUS_EE FTE PRORATE_CNT_AMT PRORATE_CNT_AMT PRORATE_CNT_AMT PRORATE_CNT_AMT PRORATE_CNT_AMT PAY_SYSTEM_FLG PAY_SYSTEM_FLG PAY_SYSTEM_FLG PAY_SYSTEM_FLG PAY_SYSTEM_FLG PAY_SYSTEM_FLG BORDER_WALKER LUMP_SUM_PAY CONTRACT_NUM JOB_INDICATOR JOB_INDICATOR JOB_INDICATOR JOB_INDICATOR JOB_INDICATOR WRKS_CNCL_ROLE_CHE WRKS_CNCL_ID_LCL BENEFIT_SYSTEM BENEFIT_SYSTEM BENEFIT_SYSTEM BENEFIT_SYSTEM WORK_DAY_HOURS SUPERVISOR_ID REPORTS_TO FORCE_PUBLISH JOB_DATA_SRC_CD JOB_DATA_SRC_CD JOB_DATA_SRC_CD JOB_DATA_SRC_CD JOB_DATA_SRC_CD ESTABID
TYPE Char Char Char Char Char Nbr Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Nbr Char Char Date Char Char Char Char Char Char
START POS 1216 1217 1218 1219 1220 1217 1221 1222 1223 1224 1225 1222 1222 1222 1222 1222 1222 1224 1225 1226 1251 1252 1253 1254 1255 1252 1282 1291 1293 1295 1297 1293 1300 1311 1319 1329 1332 1335 1338 1341 1332 Total Length
RAW LENGTH 1 1 1 1 1 4 1 1 1 1 1 2 2 2 2 2 2 1 1 25 1 1 1 1 1 30 9 2 2 2 2 7 11 8 10 3 3 3 3 3 12 1988
MASK 1 1 1 1 1 1.2 1 1 1 1 1 2 2 2 2 2 2 1 1 25 1 1 1 1 1 30 9 2 2 2 2 4.2 11 8 10 3 3 3 3 3 12
FORMAT Upper Value E M N Upper Value C N P Upper Value GP NA OT PI Upper Upper Upper Upper Value N P S Upper Upper Upper Value BA BN Upper Upper Upper Value
Upper
DESCRIPTION FICA Status-Employee Description Exempt Medicare only Subject FTE Prorate Contract Change Amount Description Prorate Over Contract Period No Proration of Change Amt. Prorate over Payment Period Payroll System Description Global Payroll Payroll for North America Other Payroll Interface Cross Border Worker Lump Sum Retro Payment Contract Number Job Indicator Description Not Applicable Primary Job Secondary Job Work Council Role Works Council ID Benefits System Description Benefits Administration Base Benefits Number of Hours in a Work Day Supervisor ID Reports To Position Number Force Publish - YYYYMMDD Job Source Code Description 0 User Generated 1 Batch Generated 2 Staff Movement Generated Establishment ID
KEY
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
CHANGES FOR 9.0
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
CHANGES FOR 9.0
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
CHANGES FOR 9.0
In 9.0 will be blank on Max Effective Dated Job Row. Use the Acct_Cd from Job_Earns_Dist
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
CHANGES FOR 9.0
** New CWR - Contingent worker EMP - Employee POI - Person of Interest
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
CHANGES FOR 9.0 ** New A - Active I - Inactive ** New SUPVR ** New ** New ** New ** New ** New ** New ** New ** New ** New ** New ** New ** New ** New ** New ** New ** New Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
CHANGES FOR 9.0 Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
CHANGES FOR 9.0 Not Used Not Used Not Used Not Used Not Used Not Used Not Used Not Used
EMPLOYEE SETUP
JOB
REVISED: 08/18/2008
CHANGES FOR 9.0
EMPLOYEE SETUP
JOB_EARNS_DIST
REVISED: 02/06/2004
FIELD NAME RECORD_NAME SSN EMPLID EMPL_RCD EFFDT EFFSEQ DEPTID JOBCODE POSITION_NBR GL_PAY_TYPE ACCT_CD SHIFT SHIFT SHIFT SHIFT SHIFT SHIFT SHIFT SHIFT LOCATION ERNCD COMPRATE DIST_PCT STD_HOURS BUSINESS_UNIT FILLER
TYPE Char Char Char Nbr Date Nbr Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Nbr Nbr Nbr Char Char
Start Position RAW LENGTH MASK FORMAT 1 8 8 Upper 9 9 9 18 11 11 Upper 29 3 3 32 10 10 42 3 3 45 10 10 Upper 55 6 6 Upper 61 8 8 Upper 69 6 6 Upper 75 25 25 Upper 100 1 1 Upper 101 1 1 Value 102 1 1 1 103 1 1 2 104 1 1 3 105 1 1 C 106 1 1 N 107 1 1 R 101 10 10 Upper 111 3 3 Upper 114 19 12.6 133 7 3.3 140 7 4.2 147 5 5 Upper 152 1192 Total Length 1350
DESCRIPTION Value: JOBEDIST Social Security Number EmplID Empl Rcd Nbr Effective Date - YYYYMMDD Effective Sequence Department Job Code Position Number General Ledger Pay Type Account Code Regular Shift Description 1 2 3 Compressed Not Applicable Rotating Location Code Earnings Code Compensation Rate Percent of Distribution Standard Hours Business Unit Spaces
KEY
NO CHANGES FOR 9.0
K K K K K K K K K K
K K
EMPLOYEE SETUP
MDC_COST_CENTER
REVISED: 02/06/2004
FIELD NAME RECORD_NAME SSN EMPLID EMPL_RCD EFFDT EFFSEQ MDC_COST_CENTER1 MDC_COST_CENTER2 MDC_COST_CENTER3 MDC_COST_CENTER4 MDC_COST_CENTR_PCT FILLER
TYPE Char Char Char Nbr Date Nbr Char Char Char Char Nbr Char
START POS 1 9 18 29 32 42 45 48 53 56 60 66 Total Length
RAW LENGTH MASK FORMAT 8 8 Upper 9 9 11 11 Upper 3 3 10 10 3 3 3 3 Upper 5 5 Upper 3 3 Upper 4 4 Upper 6 3.2 1278 1343
DESCRIPTION Value: MDCCOST Social Security Number EmplID Empl Rcd Nbr Effective Date - YYYYMMDD Effective Sequence Cost Center 1 Cost Center 1 Cost Center 3 Cost Center 4 Cost Center Percent Spaces
KEY
NO CHANGES FOR 9.0
K K K K K K K K
EMPLOYEE SETUP
MDC_JOB_DATA
REVISED: 02/06/2004
FIELD NAME RECORD_NAME SSN EMPLID EMPL_RCD EFFDT EFFSEQ MDC_WCC MDC_DIVISION MDC_SPEC_USE1 MDC_SPEC_USE2 MDC_SPEC_USE3 MDC_SPEC_USE_DT MDC_0150_REMARKS MAIL_DROP FILLER
TYPE Char Char Char Nbr Date Nbr Char Char Char Char Char Date Char Char Char
Start Position RAW LENGTH MASK FORMAT 1 8 8 Upper 9 9 9 18 11 11 Upper 29 3 3 32 10 10 42 3 3 45 4 4 Upper 49 10 10 Mixed 59 8 8 Mixed 67 8 8 Mixed 75 8 8 Mixed 83 10 10 93 500 500 Mixed 593 50 50 Mixed 643 701 Total Length 1343
DESCRIPTION Value: MDCJOBDA Social Security Number EmplID Empl Rcd Nbr Effective Date - YYYYMMDD Effective Sequence Worker's Comp Code Division Special Use 1 Special Use 2 Special Use 3 Special Use Date OPM-14 Agency Remarks Mail Drop (Sorting) Spaces
KEY
NO CHANGES FOR 9.0
K K K K
EMPLOYEE SETUP
OCP_JOB_CERT
REVISED: 07/14/2006
FIELD NAME RECORD_NAME SSN EMPLID COMPANY EMPL_RCD EFFDT EFFSEQ SEQNBR OCP_CERTIFICATE_NBR UNCLASS_CODE FILLER
TYPE Char Char Char Char Nbr Date Nbr Nbr Nbr Char Char
Start Position RAW LENGTH MASK FORMAT 1 8 8 Upper 9 9 9 18 11 11 Upper 29 3 3 32 3 3 35 10 10 45 3 3 48 15 15 63 10 10 73 6 6 Upper 79 1265 Total Length 1343
DESCRIPTION Record Name: JOBCERT Social Security Number EmplID Company Empl Rcd Nbr Effective Date Effective Sequence Sequence Number OPM Certificate Nbr Unclass Code Spaces
NO CHANGES FOR 9.0
EMPLOYEE SETUP PEOPLESOFT RAW LENG MASK FORMAT 8 8 Upper 9 9 11 11 Upper 3 3
RTRMNT_PLAN LEGACY DESCRIPTION Value: RTRPLAN Social Security Number EmplID Company TABLE FIELD TYPE LEN CONVERSION RULE ISSUES / Comments
REVISED: 01/25/2005
TYPE RECORD_NAME SSN EMPLID COMPANY
TYPE Char Char Char
START POS 1 9 18 29
NO CHANGES FOR 9.0
APSEM
EMXX-R-SSN Numeri c
Load program is looking up SSN Note: If term flag is greater
APSEMAG
APSPSPF
EMAG-C-AGCY Numeri (Agency) c 6 PSPF-C-ACCT (Activity Code)
EMPL_RCD PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE BENEFIT_NBR EFFDT DEDUCTION_END_DT COVERAGE_ELECT COVERAGE_ELECT COVERAGE_ELECT COVERAGE_ELECT COVERAGE_ELECT
Nbr Char Value 0 10 11 14 1Y 1Z 20 21 25 27 2X 30 47 48 49 4Y 4Z 50 51 60 61 70 7Y 7Z 82 Nbr Date Date Char Value E T W
32 3 3 35 2 2 Upper Description General Deduction Medical Dental Vision Dental - Dependents Medical - Dependents Life Supplemental Life Dependent Life Supplemental Life - 1st 20000 Supp Life > $50,000 Short-Term Disability Nonelective Contributions Employer Only Section 457 OPERS Administrative Fee Sick Vacation Flex Spending Health - U.S. Flex Spending Dependent Care PERS PERS 3 PERS 2 Pension Plan 1 - U.S. 37 3 3 40 8 8 48 8 8 56 1 1 Upper Description Elect Terminate Waive
Empl Rcd Nbr Plan Type
APSPSPH PSPH-CCLASS (JFD Class) See See BENEFIT_ BENEFIT_PLA
Alpha
See See BENEFI BENE
Extract program to include Agency, Department and Jobcode in extract file. Using Company (Agency), Department, and Jobcode from extract, load program to perform lookup in PS_Job (Company, Department & Jobcode) to determine Employee Record number. 70 for all Benefit Plans besides SRTD2, SRTD3. 7Z for benefit
PS Department = Activity Code from Fund and Acct Line (OPM Payroll System) +000 PS Company = Agency (OPM Payroll System) PS Jobcode = JFD Class (OPM Payrollof System) For a go-live 1/1/04, no employee with AORG Code
Benefit Number Effective Date Deduction End Date Coverage Election
N/A N/A APSPSRD N/A N/A N/A N/A
N/A N/A NUMER N/A N/A N/A N/A
Make equal to Empl_Rcd #. 8 Extract to use Begin Date on BLANK E
If an invalid date is receive,
COVERAGE_ELECT_DT
Date
57
Coverage Elect Date
PSRD-DAPSPSRD BEGIN-CYMD
NUMER IC DATE
Extract to use Begin Date on Employee Payroll Deduction 8 Page
If an invalid date is receive, load program will print out exception report.
RTRMNT_PLAN LEGACY FORMAT DESCRIPTION TABLE FIELD TYPE LEN CONVERSION RULE See New Mapping below. PSRD-C-AORG must equal one of the specified AORG codes for each plan. PSRD-C-RATE must equal one of the given rate combinations, without the commas. B ISSUES / Comments
REVISED: 01/25/2005
TYPE
TYPE
START POS
NO CHANGES FOR 9.0
BENEFIT_PLAN GVT_STAT_CHG_FLAG GVT_STAT_CHG_FLAG GVT_STAT_CHG_FLAG GVT_STAT_CHG_FLAG GVT_STAT_CHG_FLAG GVT_STAT_CHG_FLAG FILLER Total Length Old Mapping Plan Type 70 70 70 70 70 70 70 70 70 7Z 70 70 70 70 70 70 70 70 7Z 7Y 70 70 70 70 70 70
Char Char Value A B N P
65 6 71 1 Description Benefits Administration Base Benefits Not Applicable Processed 72 1272 1343
6 Upper 1 Upper
Benefit Plan Status Change Flag
PSRD-C-AORG APSPSRD PSRD-C-RATE N/A N/A N/A
N/A
Go-Live rule for 1/1/2004: Employee with AORG Code SRTD or SRTR and rate code UP, employee will be enrolled in 70 - SRTD1 and 7Y - SRTD3. B = Base Benefits
New Mapping Benefit Plan: SRJD1 AORG = SRJD, RATE CODE = J, K Exceeds benefit allowance SRJD3 AORG = SRJD, RATE CODE = J,K Does not exceed benefit allowance SRJD2 AORG = SRJD, RATE CODE = L, M Exceeds benefit allowance SRJD4 AORG = SRJD, RATE CODE = L, M Exceeds benefit allowance SRL1B AORG = SROL, RATE CODE = G and does not exceed Benefit Allowance SRL2B AORG = SROL, RATE CODE = D and does not exceed Benefit Allowance SROL1 AORG = SROL, RATE CODE = G and exceeds Benefit Allowance SROL2 AORG = SROL, RATE CODE = D and exceeds Benefit Allowance SROP1 AORG = SROP, RATE CODE = G, H, I SROP2 AORG = SROP, RATE CODE = G, H, I - Not anymore (3/12/03) SROPA AORG = SROP, RATE CODE = F4 SROPB AORG = SROP, RATE CODE =N6 SROPC AORG = SROP, RATE CODE = CTX SROPD AORG = SROP, RATE CODE = 07 SROPE AORG = SROP, RATE CODE = S9 SROPQ AORG = SROP, RATE CODE = 28 SROPY AORG = SROP, RATE CODE = 31 SRTD1 AORG = SRTD, RATE CODE = U, P SRTD2 AORG = SRTD, RATE CODE = U, P SRTD3 AORG = SRTD, RATE CODE = U, P SRTE SRTR SRTS SRTX SRWL SRWL2 AORG = SRTE, RATE CODE = U, P AORG = SRTR, RATE CODE = U, P AORG = SRTS, RATE CODE = U, P AORG = SRTX, RATE CODE = U, P AORG = SRWL, RATE CODE = P and exceeds Benefit Allowance AORG = SRWL, RATE CODE = P and does not exceed Benefit Allowance 70 70 70 70 SRJD1 AORG = SRJD, RATE CODE = J, K SRJD2 AORG = SRJD, RATE CODE = L, M SROL1 AORG = SROL, RATE CODE = G SROL2 AORG = SROL, RATE CODE = D
70 70 70 70 70 70 70 70 7Y 70 70 70 70 70
SROPA SROPB SROPC SROPD SROPE SROPQ SROPY SRTD1
AORG = SROP, RATE CODE = F4 AORG = SROP, RATE CODE =N6 AORG = SROP, RATE CODE = CTX AORG = SROP, RATE CODE = 07 O7 AORG = SROP, RATE CODE = S9 AORG = SROP, RATE CODE = 28 AORG = SROP, RATE CODE = 31 AORG = SRTD or SRTR, RATE CODE = U, P (All employee's with AORG SRTD or SRTS and Rate Code UP get enrolled in this place) SRTD3 AORG = SRTD or SRTR, RATE CODE = U, P (All employee's with AORG SRTD or SRTS and Rate Code UP get enrolled in this place) SRTE AORG = SRTE, RATE CODE = U, P SRTS SRTX SRWL OSBI AORG = SRTS, RATE CODE = U, P AORG = SRTX, RATE CODE = U, P AORG = SRWL, RATE CODE = P AORG = ORBI
EMPLOYEE SETUP PEOPLESOFT RAW LENG MASK FORMAT 8 8 Upper 9 9 11 11 Upper 3 3 3 3
SAVINGS_PLAN LEGACY DESCRIPTION Value: SAVPLAN Social Security Number EmplID Company Empl Rcd Nbr TABLE FIELD TYPE LEN CONVERSION RULE ISSUES / Comments
REVISED: 01/25/2005
TYPE RECORD_NAME SSN EMPLID COMPANY EMPL_RCD
TYPE Char Char Char Char Nbr
START POS 1 9 18 29 32
NO CHANGES FOR 9.0
APSEM N/A
EMXX-R-SSN N/A
Numeric N/A N/A
9 Load program is looking up SSN Note: If term flag is greater For employees with a single job, 49 - SoonerSave (AORG = SAST) 4Z - SoonerSave Admin Fee 4Y - AORG = SROP and Rate Cd = GHI
PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE PLAN_TYPE BENEFIT_NBR EFFDT DEDUCTION_END_DT COVERAGE_BEGIN_DT COVERAGE_END_DT COVERAGE_ELECT COVERAGE_ELECT COVERAGE_ELECT COVERAGE_ELECT COVERAGE_ELECT
Char Value 0 10 11 14 1Y 1Z 20 21 25 27 2X 30 47 48 49 4Y 4Z 50 51 60 61 70 7Y 7Z 82 Nbr Date Date Date Date Char Value E T W
35 2 2 Description General Deduction Medical Dental Vision Dental - Dependents Medical - Dependents Life Supplemental Life Dependent Life Supplemental Life - 1st 20000 Supp Life > $50,000 Short-Term Disability Nonelective Contributions Employer Only Section 457 OPERS Administrative Fee Sick Vacation Flex Spending Health - U.S. Flex Spending Dependent Care PERS PERS 3 PERS 2 Pension Plan 1 - U.S. 37 3 3 40 8 8 48 8 8 56 8 8 64 8 8 72 1 1 Description Elect Terminate Waive
Upper
Plan Type
See See BENEFIT_ BENEFIT_PLA PLAN N
See BENEFI T_PLA N
See BENE FIT_PL AN
Note: If a row for 49 exists a 4Z row must exist. If a row for 4Z exists, a 49 row must exist.
YYYYMMDD YYYYMMDD YYYYMMDD YYYYMMDD Upper
Benefit Number Effective Date Deduction End Date Coverage Begin Date Coverage End Date Coverage Election
N/A APSPSRD N/A APSPSRD N/A N/A
N/A PSRD-DN/A PSRD-DN/A N/A
N/A Numeric N/A Numeric N/A N/A
N/A N/A N/A N/A
Same as Empl Rcd #. Load 8 Extract to use Begin Date on BLANK 8 Use Begin Date on Employee BLANK E
If an invalid date is receive,
COVERAGE_ELECT_DT
Date
73
8 YYYYMMDD Coverage Elect Date
PSRD-DAPSPSRD BEGIN-CYMD
Numeric
Extract to use Begin Date on Employee Payroll Deduction 8 Page
If an invalid date is receive, load program will print out exception report.
SAVINGS_PLAN LEGACY FORMAT DESCRIPTION TABLE FIELD TYPE LEN CONVERSION RULE ISSUES / Comments For Plan Type 4Y, assign SROP if AORG = SROP and Rate Code = GHI. For Plan Types 49 and 4Z, assign SAST1 if AORG = SAST and employee is in a monthly payroll, assign SAST2 if AORG = SAST and employee is in a bi-weekly payroll. Note: If in plan type 49, e 1 for plan types 49 and 4Z. 2 for plan type 4Y
REVISED: 01/25/2005
TYPE
TYPE
START POS
NO CHANGES FOR 9.0
APSPS PSXX-C-PYRLFREQ APSPSRD BENEFIT_PLAN SAVINGS_COVRG SAVINGS_COVRG SAVINGS_COVRG SAVINGS_COVRG Char Char Value 1 2 81 87 Description Flat Amount Percent of Gross 6 1 6 Upper 1 Upper Benefit Plan Savings Coverage N/A PSRD-C-AORG N/A
Alpha
Alpha
N/A
N/A
FLAT_DED_AMT PCT_GROSS SAVINGS_COVRG_ATAX SAVINGS_COVRG_ATAX SAVINGS_COVRG_ATAX SAVINGS_COVRG_ATAX FLAT_DED_AMT_ATAX PCT_GROSS_ATAX ANN_EX_CREDITS PLAN_TYPE_RB BENEFIT_PLAN_RB DEDCD_RB DED_CLASS_RB PLAN_TYPE_RA BENEFIT_PLAN_RA DEDCD_RA DED_CLASS_RA GVT_INV_CHG_FLAG GVT_STAT_CHG_FLAG FILLER Total Length
Nbr Nbr Char Value 1 2 Nbr Nbr Nbr Char Char Char Char Char Char Char Char Char Char Char
88 97 104 Description Flat Amount Percent of Gross 105 114 121 130 132 138 144 145 147 153 159 160 161 162
9 7 1
6.2 3.3 1 Upper
Flat Deduction Amount Percent of Gross Savings Coverage AfterTax
APSPSRD PSRD-A-DED N/A N/A N/A N/A
Signed numeric N/A N/A N/A N/A
Used for Plan Type 49. All other 7 plan types get 0.00. 3.5% for Plan Type 4Y. All others 0.000. 1
9 7 9 2 6 6 1 2 6 6 1 1 1 1182 1343
6.2 3.3 6.2 2 Upper 6 Upper 6 Upper 1 Upper 2 Upper 6 Upper 6 Upper 1 Upper 1 Upper 1 Upper Spaces
Flat Deduction Amt AfterTax N/A Percent of Gross AfterTax N/A Annual Excess Credits N/A Plan Type BTAX Rollover Benefit Plan BTAX Rollover Deduction Code BTAX Rollover Deduction Class BTAX Rollover Plan Type ATAX Rollover Benefit Plan ATAX Rollover Deduction Code ATAX Rollover Deduction Class ATAX Rollover Investment Change Flag Status Change Flag N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
0.00 0.000 0 BLANK BLANK BLANK BLANK BLANK BLANK BLANK BLANK B B
EMPLOYEE SETUP
STATE_TAX_DATA
REVISED: 02/06/2004
TYPE Char
START POS
PEOPLESOFT RAW LENG MASK FORMAT 1 8 8 Upper
LEGACY DESCRIPTION Value: STATETAX KEY TABLE FIELD TYPE LENG CONVERSION RULE Extract Load will furnish the most recent row of data for employees based on the guidelines in the DR. If employee lives in one state but works in Oklahoma, Extract Load will furnish two rows of data for that employee. One row will load the Residential State data, the other will load the Working State data. ISSUES / Comments
SSN
Char
EMPLID
Char
18
11
11 Upper
EmplID
APSEMAG
EMAG-R-SSN
NUM
PS Load program is looking up SSN on PERS_NID to obtain EmplID.
COMPANY
Char
29
3 Upper
Company
APSEMAG
EMAG-C-AGY
NUM
EFFDT
Date
32
10
10
Effective Date YYYYMMDD
PS Load will use agency # to assign company code. PS Load will validate # by comparing to Company Table. Company = Agency # PS Load will pull effective date from the first row of data on employee's Date = Effective Date of the Job record. This date must agree first Job Record loaded for the with Effective Date on employee. FED_TAX_DATA. Extract Load will furnish. If the employee's Home State is not "OK", create two separate records: one for where the employee works (OK) and another for where the employee lives.
STATE
Char
42
6 Upper
State
APSAD
ADXX-L-HOMESTATE
ALPHA
Extract Load will furmish the 2-digit State Abbreviation. Situation One: The employee lives (and presumably works) in Oklahoma. Set this field to "Y". Situation Two: The employee does NOT live in Oklahoma, but presumably works in Oklahoma. When creating the record for where the employee lives (which is NOT Legacy System does not have this field.
RESIDENT NON_RES_DECLARED
Char Char
48 49
1 1
1 Upper 1 Upper
Resident Non-Residency Statement Filed
Extract Load wll furnish based on STATE field. PS Load will default = N Extract file will provide based on the following crosswalk. If legacy value = "Y" then send "G" on extract (G = "Maintain Gross" in PS) , else set to "N" (N = "None" in PS).
SPECIAL_SWT_STATUS Char SPECIAL_SWT_STATUS Char SPECIAL_SWT_STATUS SPECIAL_SWT_STATUS SPECIAL_SWT_STATUS SPECIAL_SWT_STATUS Char Char Char Char
50 51 52 53 54 55
1 1 1 1 1 1
1 Upper 1 Value 1 1 1 1 A E G N
Special Tax Status Description Non-Resident Alien; Fed Rules Exempt Maintain gross None
APSEMAG
EMAG-F-SIT
ALPHA
G = Maintain Gross but dot not pay taxes. N = there are no Special State Withholding instructions, taxes will be taken.
EMPLOYEE SETUP
STATE_TAX_DATA
REVISED: 02/06/2004
FIELD NAME
TYPE
START POS
PEOPLESOFT RAW LENG MASK
LEGACY FORMAT DESCRIPTION KEY TABLE FIELD TYPE LENG CONVERSION RULE Extract file will provide based on the following crosswalk. If legacy value = "H" or "B" then send "B" on extract (B = "Married, joint return, use optional table" in PS), If legacy value = "M" then send "M" on extract (M = "Ma Extract file will provide. PS Load default = 0 PS Load default = S. Legacy System does not have this field. Legacy System does not have this field. ISSUES / Comments
SWT_MAR_STATUS SWT_ALLOWANCES
Char Nbr
51 52 55 58 59 60 61 62 63 64 65 66 59 64 70 79
1 3 3 1 1 1 1 1 1 1 1 1 5 6 9 5.26
1 Upper 3 3 1 1 1 1 1 1 1 1 1 5 2.3 Upper Value A J L P R S U
SWT Marital/Tax Status Withholding Allowances Additional Allowances Wage Plan Code Description None/State State/Exempt Voluntary/Exempt None/None DI Exempt/State State/State Voluntary/State Annual Exemption Amount % of Federal Withholding SWT Additional Amount SWT Additional Percentage
APSEMAG APSEMAG
EMAG-CMARITALSTATUS EMAG-REXEMPT
CHAR NUM
1 2
SWT_ADDL_ALLOWNCESNbr WAGE_PLAN_CD WAGE_PLAN_CD WAGE_PLAN_CD WAGE_PLAN_CD WAGE_PLAN_CD WAGE_PLAN_CD WAGE_PLAN_CD WAGE_PLAN_CD WAGE_PLAN_CD Char Char Char Char Char Char Char Char Char
ANNL_EXEMPTION_AMT Nbr PERCENT_OF_FWT SWT_ADDL_AMT SWT_ADDL_PCT Nbr Sign Nbr
PS Load default = 0. PS Load default = 0. APSEMAG EMAG-A-W4ADDL-SIT Sign Num 6 Format must be 5.2 PS Load default = 0 Extract file will provide based on the following crosswalk. If legacy value = 'N' or 'Z' send 'N' on extract else If legacy value = 'C' send 'Y' on extract
Legacy System does not have this field. Legacy System does not have this field. Extract file will provide. Legacy System does not have this field.
2.3
SDI_STATUS SDI_STATUS SDI_STATUS SDI_STATUS SDI_STATUS SDI_STATUS
Char Char Char Char Char Char
85 86 87 88 89 90
1 1 1 1 1 1
1 1 1 1
Upper Value E N
SDI Status Description Exempt Not Applicable Voluntary Disability Plan Subject
APSEMAG
EMAG-CUNEMP
ALPHA
Some State agrencies are exempt from SUT, others aren't. If the Legacy System has N or Z in UNEMP field, then Extract Load will furnish a N meaning the agency is exempt fro SUT, else Extract file will pass a Y.
1 V 1 Y
Extract file will provide based on the following crosswalk. If legacy value = 'N' or 'Z' send 'N' on extract else If legacy value = 'C' send 'Y' on extract Some State agrencies are exempt from SUT, others aren't. If the Legacy System has N or Z in UNEMP field, then Extract Load will furnish a N meaning the agency is exempt fro SUT, else Extract file will pass a Y.
SUT_EXEMPT
Char
86
1 Upper
Exempt From SUT
APSEMAG
EMAG-CUNEMP
ALPHA
EMPLOYEE SETUP
STATE_TAX_DATA
REVISED: 02/06/2004
FIELD NAME
TYPE
START POS
PEOPLESOFT RAW LENG MASK
LEGACY FORMAT DESCRIPTION KEY TABLE FIELD TYPE LENG CONVERSION RULE ISSUES / Comments Situation One: The employee lives (and presumably works) in Oklahoma. Set this field to "Y".
UI_JURISDICTION ADDL_AMT_ADJ ADDL_AMT_ADJ ADDL_AMT_ADJ ADDL_AMT_ADJ LOCK_IN_RECVD LOCK_IN_LIMIT RETIREMENT_PLAN FILLER
Char Char Char Char Char Char Nbr Char Char Total Length
87 88 89 90 91 89 90 93 94
1 1 1 1 1 1 3 1 1250 1364
1 Upper 1 Upper 1 Value 1 D 1 I 1 Upper 3 1 Upper
UI Jurisdiction Additional Amount Adjustment Description Decrease Additional Amount Increase Additional Amount Lock-In Letter Received Limit On Allowances Retirement Plan Spaces
Extract Load wll furnish based on STATE field. Situation Two: The employee does NOT live in Oklahoma, but For Situation Two, the flag is presumably works in Oklahoma. set exactly the opposite of When creating the record for where RESIDENT. the employee lives (which is NOT Legacy system does not have this PS Load will Default = I field.
PS Load will Default - N PS Load will Default = 0 PS Load will default = 'N'
Legacy system does not have this field. Legacy system does not have this field. This field is only used for Puerto Rico employees.
EMPLOYEE SETUP
STATE_TAX_DATA
REVISED: 02/06/2004
NO CHANGES FOR 9.0
EMPLOYEE SETUP
STATE_TAX_DATA
REVISED: 02/06/2004
NO CHANGES FOR 9.0
EMPLOYEE SETUP
STATE_TAX_DATA
REVISED: 02/06/2004
NO CHANGES FOR 9.0
EMPLOYEE SETUP TABLES
COMPENSATION
REVISED: 05/07/2004
FIELD NAME RECORD_NAME SSN EMPLID EMPL_RCD EFFDT EFFSEQ COMP_EFFSEQ COMP_RATECD COMP_RATE_POINTS COMPRATE COMP_PCT COMP_FREQUENCY CURRENCY_CD MANUAL_SW CONVERT_COMPRT RATE_CODE_GROUP CHANGE_AMT CHANGE_PCT CHANGE_PTS FTE_INDICATOR CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND CMP_SRC_IND FILLER
TYPE START POSITION RAW LENGTH Char 1 8 Char 9 9 Char 18 11 Nbr 29 3 Date 32 8 Nbr 40 3 Nbr 43 3 Char 46 6 Nbr 52 5 Nbr 57 12 Nbr 69 7 Char 76 5 Char 81 3 Char 84 1 Nbr 85 12 Char 97 6 Sign 103 12 Sign 115 8 Sign 123 6 Char 129 1 Char 130 1 Char 130 1 Char 130 1 Char 130 1 Char 130 1 Char 130 1 Char 130 1 Char 130 1 Char 130 1 Char 130 1 Char 130 1 Char 130 1 Char 131 1213
LENGTH
8.2-
8.28.23.35-
FORMAT DESCRIPTION 8 Upper Value: COMP 9 11 Upper EmplID 3 Empl Rcd Nbr 8 YYYYMMDD Effective Date 3 Effective Sequence 3 Compensation Eff Sequence 6 Upper Comp Rate Code 5 Comp Rate Points Compensation Rate 3.3 Comp Percent 5 Upper Compensation Frequency 3 Upper Currency Code 1 Upper Manual Row Switch Converted Comp Rate 6 Upper Rate Code Group Name Change Amount Change Percent Change Points 1 Upper Apply FTE for Annualization 1 Upper Rate Code Source 1 Value Description 1 A Absorbing Premium 1 B Non-Absorbing Premium 1 C Combination Rule 1 E Seniority Pay 1 J Job Code 1 M Manual 1 N None 1 P Payroll 1 R Employee Review 1 S Salary Step Spaces
KEY
NO CHANGES FOR 9.0
K K K K K K
COMPENSATION
REVISED: 05/07/2004
FIELD NAME
TYPE START POSITION RAW LENGTH LENGTH Total Length 1354
FORMAT
DESCRIPTION
KEY
NO CHANGES FOR 9.0
JOB JR
REVISED: 08/18/2008
FIELD NAME RECORD NAME SSN EMPLID EMPL_RCD EFFDT EFFSEQ LASTUPDDTTM LASTUPDOPRID TAXCODE_UK TAX_BASIS_UK WORKER_TYPE_MEX REDUCED_WEEK_MEX LOCATED_CD_MEX SALARY_TYPE_MEX IMS_TERM_DT_MEX CASUAL_IND SALARY_PACKAGED PAYROLL_STATE_AUS CLASSN_CURRENT_AUS WORK_SECTOR_AUS FUNCTION_AUS ANN_CNTACT_HRS_AUS TEACH_WEEKS_AUS CASUAL_TYPE_AUS TERM_TYPE_AUS TERM_LTD_AUS BALANCE_GRP_NUM FP_ACTION_2 CTG_RATE FP_LEGALSTAT_CD FP_SCNDMT_CD FP_SCND_TYP FP_CIVIL_PENSION FP_SOURCE_ORG FP_RECEP_ORG FP_RETURN_CD FP_PR_LEGSTA FP_FOREND_DT FP_END_DT FP_CAREFRZPCT FP_HIR_DOS_SIT FP_PT_PCT_DET FP_TITLE_NUM
TYPE CHAR CHAR CHAR NBR DATE NBR DTTM CHAR CHAR CHAR CHAR CHAR CHAR CHAR DATE CHAR CHAR CHAR NBR CHAR CHAR NBR NBR CHAR CHAR NBR CHAR CHAR NBR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR DATE DATE NBR CHAR CHAR CHAR
START POS 1 9 18 29 32 42 45 71 101 116 117 121 125 143 147 157 158 159 162 165 166 167 174 176 177 179 181 184 187 190 193 194 195 196 246 276 277 280 290 300 303 305 308
RAW LENGTH MASK FORMAT 8 8 9 9 11 11 UPPER 3 3 10 10 3 3 26 26 SCNDS 30 30 MIXED 15 15 UPPER 1 1 UPPER 4 4 UPPER 4 4 UPPER 18 18 UPPER 4 4 UPPER 10 10 1 1 UPPER 1 1 UPPER 3 3 3 3 1 1 UPPER 1 1 UPPER 7 4.2 2 2 1 1 UPPER 2 2 UPPER 2 2 3 3N 3 3 UPPER 3 3 3 3 UPPER 1 1 UPPER 1 1 UPPER 1 1 UPPER 50 50 MIXED 30 30 MIXED 1 1 UPPER 3 3 UPPER 10 10 10 10 3 3 2 2 NUM 3 3 NUM 10 10 NUM
DESCRIPTION Value: JOBJR SSN ID EMPL RCD# EFF DATE SQUENCE LASTUPD DTTM LAST UPD USER TAX CODE TAX BASIS WORKER TYPE Week/Reduc Locat Cd Sal Type IMSS Term Dt
KEY K K K K K K
CHANGES FOR 9.0
Classification Work Sector Job Function Ann Cntct Hrs Teaching Weeks Work Performed appoint Type Job Duration Bal Grp No Act Retro Evnt Rate Civ Serv Poist on Secondment Type secondment Type Job Cvil Pens Home Org Receiving Org Return Pst bf Rehiring Expected End Dt Actual End Dt Car Adv Hire Status work Time% Secdmt Title Nber
Blank, Used only for AUS Blank, Used only for AUS Blank, Used only for AUS Zeros, Used only for AUS Blank, Used only for AUS Blank, Used only for AUS Zeros, Used only for AUS Zeros, Used only for AUS Blank, Used only for AUS Blank, Used only for AUS Zeros, Used only for AUS
JOB JR
REVISED: 08/18/2008
FP_DURATION_PCT FP_RATING_PRS_FLG FP_BUDGET_NBR FP_HDCNT_NBR FP_POTENT_NBR FP_RANK_CD FP_STEP_CD FP_RK_ENT_DT FP_CORPS_CD FP_CHG_COR_DT FP_CATG_FP FP_CATG_LEVEL FP_RK_TRIALPD FP_STEP_END_DT FP_FOR_PROM_DT FP_NOMINATION_DT FP_TRAINEE FP_TRNE_POSN FP_RK_PD_END_DT FP_SANCTION FP_DOWN_GRA FP_APPL_SAL_DT FP_CHG_IND FP_CLD_INST FP_SETID_RANK FP_INSTALL_DT FP_EQUIV_STEP FP_STEP_CD2 FP_BUSINESS_CD FP_APPL_DT FP_CHG_SAL FP_POINTYP_CD FP_GROSS_IND FP_INCS_IND FP_INCS_IND2 FP_PT_PCT FP_PT_END_DT FP_PT_FOREND_DT FP_COMPRATE FP_INST_STAT FP_RETROSPECT FP_ROW_END_DT LAST_UPDATE_DATE OTHER_ID_JPN
NBR CHAR NBR NBR NBR CHAR CHAR DATE CHAR DATE CHAR CHAR CHAR DATE DATE DATE CHAR CHAR DATE CHAR CHAR DATE CHAR CHAR CHAR DATE CHAR CHAR CHAR DATE CHAR CHAR NBR NBR NBR CHAR DATE DATE NBR CHAR CHAR DATE DATE CHAR
318 321 322 323 324 325 331 335 345 351 361 363 366 367 377 387 397 398 399 409 410 411 421 422 423 428 438 442 446 450 460 461 463 467 471 475 478 488 498 517 518 519 529 539
3 1 1 1 1 6 4 10 6 10 2 3 1 10 10 10 1 1 10 1 1 10 1 1 5 10 4 4 4 10 1 2 4 4 4 3 10 10 19 1 1 10 10 11
3 1 1 1 1 6 4 10 6 10 2 3 1 10 10 10 1 1 10 1 1 10 1 1 5 10 4 4 4 10 1 2 4 4 4 3 10 10 12.6 1 1 10 10 11
UPPER
UPPER UPPER UPPER UPPER UPPER UPPER
UPPER UPPER UPPER UPPER UPPER UPPER UPPER UPPER UPPER UPPER UPPER UPPER
NUM
UPPER UPPER
UPPER
Adv%Serv Lgth Rating Att bdgt Hdcnt Stat Hdcount Potential FTE Grade Step Grade Entry Dte Corps Corps Chg Dt CS Catgy level Prob Period Step Actl EndDt Expected adv Dt Apptmnt Date Trainee PPD State PPd End Dt Sanction Demotion Comp App Dt Forced Ind Instce Termntd Grade SetID Install Dt Corr[ Stp Step occupation Applic Dt Forced Sal pt Type Cd Gross Ind incrsd Ind Incrsd Ind 2 Work Time % PT end Dt PT Exptd End Dt Comp Rate Actual/Req Retoactivity JOBInst End Dt Dt of last upd Internal EmplID
JOB JR
REVISED: 08/18/2008
INTCP_XFR_FLG INTCP_XFR_START_DT INTCP_XFR_END_DT INTCP_BUS_UNIT INTCP_DEPTID INTCP_DEPTID2 INTCP_SETID_DEPT INTCP_COMPANY INTCP_COMPANY2 INTCP_SUPV_LVL_ID INTCP_SUPV_LVL_ID2 SUPV_LVL_ID EXPECTED_END_DATE AUTO_END_FLG DUTIES_TYPE ASSIGNMENT_ID TARGET_COMPRATE CMP_DONT_ABSORB SSN_EMPLOYER UNITA_PROD_CD ACTION_ITA ACTION_REASON_ITA SPECIAL_HIRCTG_ITA PART_TIME_TYPE_ITA PART_TIME_PERC_ITA PARTTIME_ENDDT_ITA FILLER
CHAR DATE DATE CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR DATE CHAR CHAR NBR NBR CHAR CHAR CHAR CHAR CHAR CHAR CHAR NBR DATE Char Total Length
550 551 561 571 576 586 596 601 604 607 615 623 631 641 642 644 652 671 672 685 691 694 697 698 699 707 717
1 10 10 5 10 10 5 3 3 8 8 8 10 1 2 8 19 1 13 6 3 3 1 1 8 10 627 1343
1 10 10 5 10 10 5 3 3 8 8 8 10 1 2 8 12.6 1 13 6 3 3 1 1 3.4 10 627
UPPER
UPPER UPPER UPPER UPPER UPPER UPPER UPPER UPPER UPPER UPPER UPPER
UPPER UPPER UPPER UPPER UPPER UPPER UPPER
int Xfr Flag int Xfr St Dt Int Xfr End Dt Int Xfr BU Int Xfr DeptID Int Xfr DeptID Int Xfr SetID Int Xfr Company Int Xfr Company Int Xfr Supv ID Int Xfr Supv ID Supervisor Lvl Planned Exit Auto End Job Duties Type Assignment # Target Comprate Don't Absor SSN Employer Prod Unit Action Action Reason Hiring Category Part_Time Type Percentage End Date
Spaces
FIELD NAME
TYPE
START POS
RAW LENGTH
MASK
FORMAT
DESCRIPTION
KEY
RECORD NAME SSN EMPLID EMPL_RCD EFFDT END_EFFDT SCHEDULE_GRP SETID SCH_ADHOC_IND SCHEDULE_ID ROTATION_ID USE_DFLT_WS ALT_SCHEDULE_GRP SETID_SCHED SCH_ADHOC_IND_ALT ALT-WRK_SCHED_ID ROTATION_ID_ALT USE_ALT_DFLT_WS Filler
Char Char Char Nbr Date Date Char Char Char Char Char Char Char Char Char Char Char Char Char Total Length
1 9 18 29 32 42 52 62 67 68 84 94 95 105 1110 111 127 137 138
8 9 11 3 10 10 10 5 1 16 10 1 10 5 1 16 10 1 1206 1343
Upper Upper Upper
Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper
Value:SCHASGN Soc Sec Nbr EmplID K Empl Rcd Nbr K Effective Date K End Effdt Schedule Group SetID Ad Hoc Schedule Indicator Schedule ID Rotation ID Assignment Method Alternate Schedule Group Schedule SetID Ad Hoc Schedule Indicator Alternate Work Schedule Alternate Rotation ID Assignment Method space
FIELD NAME
TYPE
START POS
RAW LENGTH
MASK
FORMAT
DESCRIPTION
KEY
RECORD NAME SSN EMPLID EMPL_RCD EFFDT COMP_TIME_PLAN EFF_STATUS Filler
Char C Char Nbr Date Char Char Char
1 9 18 29 32 42 52 53 Total Length
8 9 11 3 10 10 1 1291 1343
Upper Upper
Upper Upper
Value:TLEMPCOM Soc Sec Nbr EmplID Empl Rcd Nbr Effective Date Compensatory Time Off Plan Status as of Effective Date space
K K K K
FIELD NAME
TYPE
START POS
RAW LENGTH
MASK
FORMAT
DESCRIPTION
KEY
RECORD NAME SSN EMPLID EMPL_RCD EFFDT TIME_RPTG_STATUS TIME_RPTR_IND ELP_TR_TMPLT_IND PCH_TR_TMPLT_ID PERIOD_ID WORKGROUP TASKGROUP TASK_PROFILE_ID TCD_GROUP_ID RESTRICTION_PRF_IND TTIME_TO_PAY RULE_ELEMENT_1 RULE_ELEMENT_2 RULE_ELEMENT_3 RULE_ELEMENT_4 RULE_ELEMENT_5 TIMEZONE Filler
Char Char Char Nbr Date Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Char Total Length
1 9 18 29 32 42 43 44 54 64 76 86 96 106 116 126 127 137 147 157 167 177 186
8 9 11 3 10 1 1 10 10 12 10 10 10 10 10 1 10 10 10 10 10 9 1158 1343
Upper Upper
Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper Upper
Value:TLEMPDAT Soc Sec Nbr EmplID Empl Rcd Nbr Effective Date Time Reporter Status Time Reporter Indicator Elapsed Reporting Template Punch Reporting Template Time Period ID Workgroup Taskgroup Task Profile ID TCD Group ID Restriction Profile ID Send Time to Payroll Rule Element 1 Rule Element 2 Rule Element 3 Rule Element 4 Rule Element 5 Time Zone space
K K K

Employee Setup Tables

Uploaded by

Copyright:

Available Formats

Employee Setup Tables

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Employee Setup Tables

Uploaded by

Copyright:

Available Formats

What information is provided about employee setup additional pay data?

What information is provided about employee setup additional pay data?

What fields are no longer being populated in the ADDLPAY table and why?

What fields are no longer being populated in the ADDLPAY table and why?

EMPLOYEE SETUP

PEOPLESOFT RAW LENG 1 9 8 9

LEGACY NO CHANGES FOR 9.0

FIELD NAME RECORD_NAME SSN

TYPE Char Char

DESCRIPTION Value: ADDLPAY Social Security Number

APSPSPH EMPL_RCD Nbr 29 3 3 Empl Rcd Nbr K

Earnings Code Effective Date YYYYMMDD

Additional Pay Sequence Number

General Ledger Pay Type

LEGACY NO CHANGES FOR 9.0

FORMAT Upper Value 1 2 3 J N

CONVERSION RULE PS Load will default to 'N' (Not Applicable)

12 8.23 3 3 3 3 3 3 3 3 3 3 3 3 1 10 12 8.212 8.21 1 1 1 1 3 3 3 3 3 3 3 3 3 3 3 3 3 1 10 Upper Value A AWD BAS C JOB N O P Q RET S

PSPH-A-SPEC- Signed PAY Dec

Upper Upper Upper Upper Upper

Second Pay Period

PS Load will default to 'N".

PAY_PERIOD3 PAY_PERIOD4 PAY_PERIOD5 STATE LOCALITY

Char Char Char Char Char

186 187 188 189 195

Upper Upper Upper Upper Upper

PEOPLESOFT RAW LENG

LEGACY NO CHANGES FOR 9.0

PS Load will default to 'P' (Use Pay Group Frequency)

PS Load will default to 'N'.

PS Load will leave Blank.

PS Load will default to Blank. PS Load will default to Blank.

LEGACY NO CHANGES FOR 9.0

BUSINESS_UNIT COMP_RATECD RECORD_SOURCE FILLER

Char Char Char Char

219 224 230 231 Total Length

Upper Upper Upper

Business Unit Comp Rate Code Record Source Spaces

PEOPLESOFT RAW LENG 1 9 8 9

LEGACY NO CHANGES FOR 9.0

FIELD NAME RECORD_NAME SSN

TYPE Char Char

DESCRIPTION Value: ADDLEFF Social Security Number

LEN CONVERSION RULE

PSXX-C-AGCY Num (Agency) PSPF-C-ACCT (Activity Code) Num

APSPSPH EMPL_RCD Nbr 29 3 3 Empl Rcd Nbr K

PSPH-C-CLASS Alpha (JFD Class)

Extract Load will furnish Agency #.

EFFDT RECORD_SOURCE RECORD_SOURCE RECORD_SOURCE RECORD_SOURCE FILLER

Date Char Char Char Char Char

Effective Date YYYYMMDD Record Source Description Batch On-line Spaces

PEOPLESOFT RAW LENG 1 9 8 9

FIELD NAME RECORD_NAME SSN

TYPE Char Char

DESCRIPTION Value: ADDLEARN Social Security Number

LEN CONVERSION RULE

PSXX-R-SSN PSXX-C-AGCY (Agency) PSPF-C-ACCT (Activity Code)

APSPSPH EMPL_RCD Nbr 29 3 3 Empl Rcd Nbr K

PSPH-C-CLASS Alpha (JFD Class)