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