Docstoc

PeopleSoft Employee Setup Tables - Excel

Document Sample
PeopleSoft Employee Setup Tables - Excel Powered By Docstoc
					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

				
DOCUMENT INFO