Hire Business Case Saes by ihh16957

VIEWS: 23 PAGES: 74

Hire Business Case Saes document sample

More Info
									EMPLOYEE SETUP                                                                                    ADDL_PAY_DATA                                                                                               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: 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
                                             RAW                                                                                                                                                                              CHANGES
FIELD NAME          TYPE   START 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)
ADDL_PAY_SHIFT      Char               103       1         1         Value   Description
ADDL_PAY_SHIFT      Char               104       1         1           1                               1
ADDL_PAY_SHIFT      Char               105       1         1           2                               2
ADDL_PAY_SHIFT      Char               106       1         1           3                               3
ADDL_PAY_SHIFT      Char               107       1         1           J     Use Job Shift
ADDL_PAY_SHIFT      Char               108       1         1           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).
ADDLPAY_REASON      Char               145          3           3    Value   Description
ADDLPAY_REASON      Char               148          3           3      A     Anniversary Award
ADDLPAY_REASON      Char               151          3           3    AWD     Award Data
                                                                             Benefits Administration
ADDLPAY_REASON      Char               154          3           3     BAS    Credit
ADDLPAY_REASON      Char               157          3           3      C     Contract Pay
ADDLPAY_REASON      Char               160          3           3     JOB    Job Other Pay
ADDLPAY_REASON      Char               163          3           3      N     Not Specified

ADDLPAY_REASON      Char               166          3           3      O     Outstanding Contribution
ADDLPAY_REASON      Char               169          3           3      P     Performance Award
ADDLPAY_REASON      Char               172          3           3      Q     President's Award
ADDLPAY_REASON      Char               175          3           3     RET    Retirement Calculation
ADDLPAY_REASON      Char               178          3           3      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
                                              RAW                                                                                                                                                       CHANGES
FIELD NAME           TYPE   START 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).
TAX_METHOD           Char               208          1          1    Value   Description
TAX_METHOD           Char               209          1          1      A     Annualized
TAX_METHOD           Char               210          1          1      B     Bonus
TAX_METHOD           Char               211          1          1      C     Cumulative
TAX_METHOD           Char               212          1          1     G      Aggregate
TAX_METHOD           Char               213          1          1      L     Lump Sum
TAX_METHOD           Char               214          1          1     M      Commission
TAX_METHOD           Char               215          1          1      P     Specified on Paysheet
TAX_METHOD           Char               216          1          1      S     Supplemental
TAX_METHOD           Char               217          1          1      X     Special Supplemental
                                                                                                                                             PS Load will default to 'P' (Use
ADDL_PAY_FREQUENCY   Char               208          1          1    Upper   Tax Frequency                                                   Pay Group Frequency)
ADDL_PAY_FREQUENCY   Char               208          1          1    Value   Description
ADDL_PAY_FREQUENCY   Char               208          1          1      A     Annually
ADDL_PAY_FREQUENCY   Char               208          1          1      B     Biweekly
ADDL_PAY_FREQUENCY   Char               208          1          1      D     Daily
ADDL_PAY_FREQUENCY   Char               208          1          1     M      Monthly
                                                                             Use Pay Group
ADDL_PAY_FREQUENCY   Char               208          1          1      P     Frequency
ADDL_PAY_FREQUENCY   Char               208          1          1     Q      Quarterly
ADDL_PAY_FREQUENCY   Char               208          1          1      S     Semimonthly
ADDL_PAY_FREQUENCY   Char               208          1          1     W      Weekly
DED_TAKEN            Char               209          1          1    Upper   Deductions Taken                                                PS Load will default to 'N'.
DED_TAKEN            Char               209          1          1    Value   Description

DED_TAKEN            Char               209          1          1      D     Deduction Table Governs
DED_TAKEN            Char               209          1          1      N     None
DED_TAKEN            Char               209          1          1      R     No Override
                                                                             Deduction Table Subset
DED_TAKEN            Char               209          1          1      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
DED_TAKEN_GENL       Char               214          1          1    Value   Description

DED_TAKEN_GENL       Char               215          1          1      D     Deduction Table Governs
DED_TAKEN_GENL       Char               216          1          1      N     None
DED_TAKEN_GENL       Char               217          1          1      R     No Override
                                                                             Deduction Table Subset
DED_TAKEN_GENL       Char               218          1          1      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.
PLAN_TYPE            Char               219          2          2    Value   Description
PLAN_TYPE            Char               221          2          2      0     General Deduction
PLAN_TYPE            Char               223          2          2     10     Medical
PLAN_TYPE            Char               225          2          2     11     Dental
PLAN_TYPE            Char               227          2          2     14     Vision
PLAN_TYPE            Char               229          2          2     1Y     Dental - Dependents
PLAN_TYPE            Char               231          2          2     1Z     Medical - Dependents
PLAN_TYPE            Char               233          2          2     20     Life
PLAN_TYPE            Char               235          2          2     21     Supplemental Life
PLAN_TYPE            Char               237          2          2     25     Dependent Life
EMPLOYEE SETUP                                                                                     ADDL_PAY_DATA                                                                                           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
                                                                         Supplemental Life - 1st
PLAN_TYPE        Char               239          2          2     27     20000
PLAN_TYPE        Char               241          2          2     2X     Supp Life > $50,000
PLAN_TYPE        Char               243          2          2     30     Short-Term Disability
                                                                         Nonelective
PLAN_TYPE        Char               245          2          2     47     Contributions
PLAN_TYPE        Char               247          2          2     48     Employer Only
PLAN_TYPE        Char               249          2          2     49     Section 457
PLAN_TYPE        Char               251          2          2     4Y     OPERS
PLAN_TYPE        Char               253          2          2     4Z     Administrative Fee
PLAN_TYPE        Char               255          2          2     50     Sick
PLAN_TYPE        Char               257          2          2     51     Vacation
                                                                         Flex Spending Health -
PLAN_TYPE        Char               259          2          2      60    U.S.
                                                                         Flex Spending
PLAN_TYPE        Char               261          2          2     61     Dependent Care
PLAN_TYPE        Char               263          2          2     70     PERS
PLAN_TYPE        Char               265          2          2     7Y     PERS 3
PLAN_TYPE        Char               267          2          2     7Z     PERS 2
PLAN_TYPE        Char               269          2          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 Length       1466
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.
RECORD_SOURCE    Char               46           1             1   Value   Description
RECORD_SOURCE    Char               47           1             1   B       Batch
RECORD_SOURCE    Char               48           1             1   O       On-line
FILLER           Char               46        1298                         Spaces

                        Total Length          1346
EMPLOYEE SETUP                                                                              ADDL_PAY_ERNCD                                                                                       REVISED: 02/06/2004




                                            PEOPLESOFT                                                                                        LEGACY

                                             RAW
FIELD NAME       TYPE      START POS         LENG       MASK      FORMAT    DESCRIPTION              KEY    TABLE         FIELD        TYPE    LEN CONVERSION RULE                      ISSUES / Comments
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.
RECORD_SOURCE    Char                  36         1             1   Value   Description
RECORD_SOURCE    Char                  37         1             1   B       Batch
RECORD_SOURCE    Char                  38         1             1   O       On-line
FILLER           Char                  36      1308                         Spaces

                        Total Length           1346
EMPLOYEE SETUP   ADDL_PAY_ERNCD   REVISED: 02/06/2004




   NO
CHANGES
 FOR 9.0
EMPLOYEE SETUP                                                                                     BOND_LOG                                                                                              REVISED: 02/06/2004




                                       PEOPLESOFT                                                                                        LEGACY

                                      RAW
FIELD NAME          TYPE   START POS LENG MASK FORMAT             DESCRIPTION                KEY    TABLE               FIELD     TYPE     LEN CONVERSION RULE                        ISSUES / Comments
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!@!@
BOND_LOG_STATUS     Char          41       1         1    Value   Description
BOND_LOG_STATUS     Char          42       1         1    D       Funds Disbursed
BOND_LOG_STATUS     Char          43       1         1    F       Refunded Balance
                                                                  Funds Not Ready to
BOND_LOG_STATUS     Char          44       1         1 N          Disburse

BOND_LOG_STATUS     Char          45       1         1    R       Funds Ready to Disburse
BOND_LOG_STATUS     Char          46       1         1    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.
                                                                  Pay Period End Date -
PAY_END_DT          Date         108      10        10            YYYYMMDD                                                                        PS Load will default to Blank.
EMPLOYEE SETUP                                                            BOND_LOG                                                                     REVISED: 02/06/2004




                                       PEOPLESOFT                                               LEGACY

                                    RAW
FIELD NAME       TYPE    START POS LENG MASK FORMAT   DESCRIPTION   KEY    TABLE     FIELD   TYPE   LEN CONVERSION RULE                  ISSUES / Comments
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.
AP_STATUS        Char           120     1   1 Value   Description
AP_STATUS        Char           121     1   1 S       Sent to AP
FILLER           Char           120  1224             Spaces

                        Total Length    1351
EMPLOYEE SETUP   BOND_LOG   REVISED: 02/06/2004




    NO
 CHANGES
  FOR 9.0
EMPLOYEE SETUP   BOND_LOG   REVISED: 02/06/2004




    NO
 CHANGES
  FOR 9.0
EMPLOYEE SETUP                                                                                               BOND_SPEC                                                                                 REVISED: 02/06/2004




                                                  PEOPLESOFT                                                                     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: 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

                                            RAW
FIELD NAME          TYPE   START POS        LENG       MASK      FORMAT     DESCRIPTION                 KEY    TABLE            FIELD          TYPE    LEN   CONVERSION RULE                ISSUES / Comments
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'.
BOND_OTH_REG_TYPE   Char               51          1           1    Value   Description
BOND_OTH_REG_TYPE   Char               52          1           1    B       Beneficiary
BOND_OTH_REG_TYPE   Char               53          1           1    C       Co-Owner

BOND_OTH_REG_TYPE Char                 54          1           1 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

                                                     RAW
FIELD NAME             TYPE      START POS           LENG    MASK    FORMAT   DESCRIPTION            KEY     TABLE             FIELD            TYPE     LEN   CONVERSION RULE             ISSUES / Comments
                                                                                                                                                                                           If more than one Bond is
                                                                                                                                                                                           being purchased by an
                                                                                                                                                                                           employee, then only one
                                                                                                                                                                                           of the Bond-Spec-Data
                                                                                                                                                                                           rows can have a Y
                                                                                                                                                               PS Load will set first bond entered, the other rows
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         1347


NOTE: For every employee having a Bond(s) setup in this table, PS Load will generate a row in GENL_DED_CD and GENL_DEDUCTION table for the employee. See GENL_DED_CD (bond) and GENL_DEDUCTION (bond) conversion
templates.
EMPLOYEE SETUP   BOND_SPEC_DATA   REVISED: 02/06/2004




   NO
CHANGES
 FOR 9.0
                  EMPLOYEE SETUP   BOND_SPEC_DATA   REVISED: 02/06/2004




                      NO
                   CHANGES
                    FOR 9.0




TION (bond) conversion
EMPLOYEE SETUP                             DEPT_BUDGET_ERN                                             Revised: 11/23/09


FIELD NAME           TYPE   Start Position RAW LENGTH MASK     FORMAT   DESCRIPTION
RECORD_NAME          Char                 1          8       8 Upper    Value: DEPTBGT
SSN                  Char                 9          9       9          Social Security Number
EMPLID               Char                18         11      11 Upper    EmplID
EMPL_RCD             Nbr                 29          3       3          Empl Rcd Nbr
SETID                Char                32          5       5 Upper    Setid
DEPTID               Char                37         10      10 Upper    Department
FISCAL_YEAR          Nbr                 47          4       4          Fiscal Year
POSITION_POOL_ID     Char                51          3       3 Upper    Position Pool ID
SETID_JOBCODE        Char                54          5       5 Upper    Jobcode Setid
JOBCODE              Char                59          6       6 Upper    Job Code
POSITION_NBR         Char                65          8       8 Upper    Position Number
EFFDT                Date                73         10      10          Effective Date - YYYYMMDD
EFFSEQ               Nbr                 83          3       3          Effective Sequence
ERNCD                Char                86          3       3 Upper    Earnings Code
BUDGET_SEQ           Nbr                 89          2       2          Budget Sequence Nbr
ACCT_CD              Char                91         25      25 Upper    Account Code
GL_PAY_TYPE          Char               116          6       6 Upper    General Ledger Pay Type
BUDGET_AMT           Nbr                122         19    15.3          Budget Amount
HP_EXCESS            Char               141          1       1 Upper    Allow Overspend
DIST_PCT             Nbr                142          7     3.3          Percent of Distribution
PERCENT_EFFORT       Nbr                149          6     3.2          % Effort
FUNDING_END_DT       Date               155         10      10          Funding End Date
HP_USED_DISTRIBUTN   Char               165          1       1 Upper    Used by Distribution Process
HP_FRINGE_GROUP      Char               166          5       5 Upper    Fringe Group
HP_REDIRECT_ACCT     Char               171         25      25 Upper    Redirect Account Code
FILLER               Char               196       1148                  Spaces

                            Total Length        1343
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
HOME_HOST_CLASS      Char               36       1       1 Value        Description
HOME_HOST_CLASS      Char               37       1       1 M            Home
HOME_HOST_CLASS      Char               38       1       1 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
SECURITY_CLEARANCE   Char           197        1       1   Value        Description
SECURITY_CLEARANCE   Char           198        1       1            0   Not Required
SECURITY_CLEARANCE   Char           199        1       1            1   Classified
SECURITY_CLEARANCE   Char           200        1       1            2   Secret
SECURITY_CLEARANCE   Char           201        1       1            3   Top Secret
SECURITY_CLEARANCE   Char           202        1       1            4   Sensitive Compartmented Info
SECURITY_CLEARANCE   Char           203        1       1            5   Q Sensitive
SECURITY_CLEARANCE   Char           204        1       1            6   Q Non-Sensitive
SECURITY_CLEARANCE   Char           205        1       1            7   L (Atomic Energy Act)
SECURITY_CLEARANCE   Char           206        1       1            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
DED_TAKEN            Char           232        1       1   Value        Description
DED_TAKEN            Char           233        1       1   D            Deduction Table Governs
DED_TAKEN            Char           234        1       1   N            None
DED_TAKEN            Char           235        1       1   R            No Override
DED_TAKEN            Char           236        1       1   S            Deduction Table Subset Governs
EMPLOYEE SETUP                                                                           EMPLOYMENT                                                            REVISED: 08/18/2008




FIELD NAME           TYPE                          MASK
                            Start Position RAW LENGTH           FORMAT DESCRIPTION                                  KEY                      CHANGES FOR 9.0
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
CONTRACT_LENGTH      Char             558        1          1   Upper   Contract Length                                   Blank, Not Available in 9.0
CONTRACT_LENGTH      Char             559        1          1   Value   Description
CONTRACT_LENGTH      Char             560        1          1         0 Not Applicable
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             561         1         1         1   <9 Month
CONTRACT_LENGTH      Char             562         1         1         2   9-10 Month
CONTRACT_LENGTH      Char             563         1         1         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     1366
EMPLOYEE SETUP                                                                                   FED_TAX_DATA                                                                                         REVISED: 02/06/2004




                                        PEOPLESOFT                                                                        LEGACY
                                                                                                                                                                                                                   NO
                                      RAW                                                                                                                                                                       CHANGES
FIELD NAME         TYPE   START 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).
SPECIAL_FWT_STATUS Char            43       1          1 Value     Description
SPECIAL_FWT_STATUS Char            44       1          1 A         Non-Resident Alien

SPECIAL_FWT_STATUS Char            45       1          1 E         Exempt (not subject to FIT)
                                                                                                                                                                                    Leagacy System does
                                                                                                                                                                                    not have a field fro addl
SPECIAL_FWT_STATUS Char            46       1          1 G         Maintain gross (no tax WH)                                                                                       percent values.
                                                                                                                                                                                    State employees not
SPECIAL_FWT_STATUS Char            47       1          1 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).
FWT_MAR_STATUS     Char            43       1          1   Value   Description
FWT_MAR_STATUS     Char            43       1          1   M       Married
FWT_MAR_STATUS     Char            43       1          1   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:
FWT_MAR_STATUS     Char            43       1          1                                               APSPSRD   PSRD-C-AORG       A         4      SAST, SAED                      Extract file.
FWT_ALLOWANCES     Nbr             44       3          3           FWT Allowances                      APSEMAG   EMAG-R-EXEMPT     NUM        2     Extract file will provide.
EMPLOYEE SETUP                                                                         FED_TAX_DATA                                                                                          REVISED: 02/06/2004




                                      PEOPLESOFT                                                               LEGACY
                                                                                                                                                                                                          NO
                                     RAW                                                                                                                                                               CHANGES
FIELD NAME       TYPE   START POS    LENG     MASK FORMAT     DESCRIPTION              KEY     TABLE         FIELD        TYPE     LENGTH    CONVERSION RULE               ISSUES / Comments            FOR 9.0
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"
EIC_STATUS       Char            63       1         1 Value   Description
                                                              Married, both spouses
EIC_STATUS       Char            64       1         1 M       filing
EIC_STATUS       Char            65       1         1 N       Not applicable
                                                              Single,or Head of
EIC_STATUS       Char            66       1         1 S       Household
                                                              Married without spouse
EIC_STATUS       Char            67       1         1 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
                                                 RAW                                                                                                                                                                  CHANGES
FIELD NAME           TYPE     START 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'.
FORM_1001_RECD       Char                  100       1         1    Value    Description
FORM_1001_RECD       Char                  101       1         1    N        No
FORM_1001_RECD       Char                  102       1         1    X        Not Applicable
FORM_1001_RECD       Char                  103       1         1    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'.
FORM_8233_RECD       Char                  121       1         1    Value    Description
FORM_8233_RECD       Char                  122       1         1    N        No
FORM_8233_RECD       Char                  123       1         1    X        Not Applicable
FORM_8233_RECD       Char                  124       1         1    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

                            Total Length          1365
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
PAY_PERIOD       Char               44             1       1 Value     Description
PAY_PERIOD       Char               45             1       1       1   First
PAY_PERIOD       Char               46             1       1       2   Second
PAY_PERIOD       Char               47             1       1       3   Third
PAY_PERIOD       Char               48             1       1       4   Fourth
PAY_PERIOD       Char               49             1       1       5   Fifth
GARN_DED_CALC    Char               44             1       1 Upper     Garnish Deduction Calc Routine
GARN_DED_CALC    Char               44             1       1 Value     Description
GARN_DED_CALC    Char               44             1       1 G         Greater of %DE or Amount
GARN_DED_CALC    Char               44             1       1 H         Greater of %Gross or Amount
GARN_DED_CALC    Char               44             1       1 M         Maximum Allowed
GARN_DED_CALC    Char               44             1       1 P         % DE + Amount
GARN_DED_CALC    Char               44             1       1 R         % Gross + Amount
GARN_DED_CALC    Char               44             1       1 S         No exempt; %DE + Amt
GARN_DED_CALC    Char               44             1       1 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            1357
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
GARN_STATUS      Char            39               1        1 Value    Description
GARN_STATUS      Char            40               1        1 A        Garnishment Request Approved
GARN_STATUS      Char            41               1        1 C        Garnishment Deduct Completed
GARN_STATUS      Char            42               1        1 J        Garnishment Request Rejected
GARN_STATUS      Char            43               1        1 R        Garnishment Request Received
GARN_STATUS      Char            44               1        1 S        Garnishment Deduct Suspended
GARN_TYPE        Char            39               1        1 Upper    Garnish Type
GARN_TYPE        Char            39               1        1 Value    Description
GARN_TYPE        Char            39               1        1 A        Wage Assignment
GARN_TYPE        Char            39               1        1 B        Chapter 13 Bankruptcy
GARN_TYPE        Char            39               1        1 C        Child Support
GARN_TYPE        Char            39               1        1 D        Dependent Support
GARN_TYPE        Char            39               1        1 L        Tax Levy
GARN_TYPE        Char            39               1        1 S        Spousal Support
GARN_TYPE        Char            39               1        1 T        Student Loan Repayment
GARN_TYPE        Char            39               1        1 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
GARN_LIMIT_AMT   Nbr            592               9      6.2          Garnish Limit Amount
GARN_LIMIT_BAL   Nbr            601               9      6.2          Garnish Limit Balance
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_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
GARN_DED_SCHED       Char            662           1       1 Value   Description
GARN_DED_SCHED       Char            663           1       1 A       Deduct on All Payrolls
GARN_DED_SCHED       Char            664           1       1 S       Deduct by Schedule
GARN_DED_CALC        Char            662           1       1 Upper   Garnish Deduction Calc Routine
GARN_DED_CALC        Char            662           1       1 Value   Description
GARN_DED_CALC        Char            662           1       1 G       Greater of %DE or Amount
GARN_DED_CALC        Char            662           1       1 H       Greater of %Gross or Amount
GARN_DED_CALC        Char            662           1       1 M       Maximum Allowed
GARN_DED_CALC        Char            662           1       1 P       % DE + Amount
GARN_DED_CALC        Char            662           1       1 R       % Gross + Amount
GARN_DED_CALC        Char            662           1       1 S       No exempt; %DE + Amt
GARN_DED_CALC        Char            662           1       1 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
GARN_SUPPORT_TYPE    Char            977           1       1 Value   Description
GARN_SUPPORT_TYPE    Char            978           1       1 A       Arrears Order
GARN_SUPPORT_TYPE    Char            979           1       1 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
AP_PAYMENT_DT_TYPE   Char           1018           1       1 Value   Description
AP_PAYMENT_DT_TYPE   Char           1019           1       1 C       Check Date
AP_PAYMENT_DT_TYPE   Char           1020           1       1 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

                            Total Length       1375
EMPLOYEE SETUP                                                                      GENL_DEDUCTION                                                                                  REVISED: 08/23/2004

                                             PEOPLESOFT                                                                        LEGACY
                                             RAW
  TYPE               TYPE      START POS     LENG   MASK   FORMAT        DESCRIPTION               TABLE      FIELD     TYPE    LEN   CONVERSION RULE                     ISSUES / Comments
  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
  DED_CALC               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
                                                    RAW
  TYPE                TYPE      START POS           LENG   MASK         FORMAT   DESCRIPTION                 TABLE       FIELD      TYPE    LEN   CONVERSION RULE                  ISSUES / Comments

                                                                                                                                                                                   This field works in
                                                                                                                                                                                   conjunctions with the
                                                                                                                                                                                   above field. It is the
                                                                                                                                                                                   amount that has been paid
                                                                                                                                                                                   so far. When this field is
                                                                                                                                                                                   equal to above field, Goal
                                                                                                                                                                                   Amount, the deduction
  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
EMPLOYEE SETUP   GENL_DEDUCTION   REVISED: 08/23/2004


                 NO CHANGES FOR
                       9.0
EMPLOYEE SETUP   GENL_DEDUCTION   REVISED: 08/23/2004


                 NO CHANGES FOR
                       9.0
                                            Gen Deduction Code Crosswalk


Peoplesoft System                                                                 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


                                   e2360e65-99bb-47af-8879-1cf7cacc170f.xls                       Page 32
                                              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




                                     e2360e65-99bb-47af-8879-1cf7cacc170f.xls                       Page 33
                                         Gen Deduction Code Crosswalk


Peoplesoft System                                                              Legacy System

                                                                   Deduction
                           Description
                                                                    Code       Object Code
Goldman SACHS Funds                                               SAFJ         SAFJ
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.




                                 e2360e65-99bb-47af-8879-1cf7cacc170f.xls                      Page 34
D:\Docstoc\Working\pdf\e2360e65-99bb-47af-8879-1cf7cacc170f.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 35 of 74
D:\Docstoc\Working\pdf\e2360e65-99bb-47af-8879-1cf7cacc170f.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 36 of 74
EMPLOYEE SETUP                                                  JOB                                          REVISED: 08/18/2008



                                         RAW
FIELD NAME           TYPE   START POS   LENGTH   MASK   FORMAT        DESCRIPTION                      KEY
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
EMPL_STATUS          Char       72         1       1    Value         Description
EMPL_STATUS          Char       73         1       1    A             Active
EMPL_STATUS          Char       74         1       1    D             Deceased
EMPL_STATUS          Char       75         1       1    L             Leave of Absence
EMPL_STATUS          Char       76         1       1    P             Leave With Pay
EMPL_STATUS          Char       77         1       1    Q             Retired With Pay
EMPL_STATUS          Char       78         1       1    R             Retired
EMPL_STATUS          Char       79         1       1    S             Suspended
EMPL_STATUS          Char       80         1       1    T             Terminated
EMPL_STATUS          Char       81         1       1    U             Terminated With Pay
EMPL_STATUS          Char       82         1       1    V             Terminated Pension Pay Out
EMPL_STATUS          Char       83         1       1    W             Short Work Break
EMPL_STATUS          Char       84         1       1    X             Retired-Pension Administration
ACTION               Char       72         3       3    Upper         Action
ACTION               Char       72         3       3    Value         Description
ACTION               Char       72         3       3    ADD           Add Non-Employee
ACTION               Char       72         3       3    ADL           Additional Job
ACTION               Char       72         3       3    DEM           Demotion
ACTION               Char       72         3       3    DET           Detail
ACTION               Char       72         3       3    DTA           Data Change
ACTION               Char       72         3       3    EDT           End of Detail
ACTION               Char       72         3       3    HIR           Hire
ACTION               Char       72         3       3    JRC           Job Reclassification
ACTION               Char       72         3       3    LOA           Leave of Absence
ACTION               Char       72         3       3    PAY           Pay Rate Change
ACTION               Char       72         3       3    PLA           Paid Leave of Absence
ACTION               Char       72         3       3    POS           Position Change
ACTION               Char       72         3       3    PRB           Probation
ACTION               Char       72         3       3    PRC           Completion of Probation
ACTION               Char       72         3       3    PRO           Promotion
ACTION               Char       72         3       3    REC           Recall from Suspension/Layoff
ACTION               Char       72         3       3    REH           Rehire
ACTION               Char       72         3       3    RET           Retirement
EMPLOYEE SETUP                                                 JOB                                                    REVISED: 08/18/2008



                                        RAW
FIELD NAME          TYPE   START POS   LENGTH   MASK   FORMAT            DESCRIPTION                            KEY
ACTION              Char       72         3       3    RFL               Return from Leave
ACTION              Char       72         3       3    SUS               Suspension
ACTION              Char       72         3       3    TER               Termination
ACTION              Char       72         3       3    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
SHIFT               Char      139         1       1    Value             Description
SHIFT               Char      140         1       1                  1                                      1
SHIFT               Char      141         1       1                  2                                      2
SHIFT               Char      142         1       1                  3                                      3
SHIFT               Char      143         1       1    C                 Compressed
SHIFT               Char      144         1       1    N                 Not Applicable
SHIFT               Char      145         1       1    R                 Rotating
REG_TEMP            Char      139         1       1    Upper             Regular/Temporary
REG_TEMP            Char      139         1       1    Value             Description
REG_TEMP            Char      139         1       1    E                 Seaonal Employee
REG_TEMP            Char      139         1       1    P                 Projects
REG_TEMP            Char      139         1       1    R                 Regular
REG_TEMP            Char      139         1       1    S                 Student Employee
REG_TEMP            Char      139         1       1    T                 Temporary
FULL_PART_TIME      Char      140         1       1    Upper             Full/Part Time
FULL_PART_TIME      Char      140         1       1    Value             Description
FULL_PART_TIME      Char      140         1       1    F                 Full-Time
FULL_PART_TIME      Char      140         1       1    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
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
BEN_STATUS          Char      244         4       4    Value             Description
BEN_STATUS          Char      248         4       4    A                 Active
EMPLOYEE SETUP                                                  JOB                                          REVISED: 08/18/2008



                                        RAW
FIELD NAME          TYPE   START POS   LENGTH   MASK    FORMAT        DESCRIPTION                      KEY
BEN_STATUS          Char      252         4       4     D             Deceased
BEN_STATUS          Char      256         4       4     L             Leave of Absence
BEN_STATUS          Char      260         4       4     P             Leave With Benefits
BEN_STATUS          Char      264         4       4     Q             Retired With Benefits
BEN_STATUS          Char      268         4       4     R             Retired
BEN_STATUS          Char      272         4       4     S             Suspended
BEN_STATUS          Char      276         4       4     T             Terminated
BEN_STATUS          Char      280         4       4     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
OFFICER_CD          Char      270         1       1     Value         Description
OFFICER_CD          Char      271         1       1     E             Elected Official
OFFICER_CD          Char      272         1       1     J             Judicial
OFFICER_CD          Char      273         1       1     L             Legislator
OFFICER_CD          Char      274         1       1     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



ACCT_CD             Char      308        25       25    Upper         Account Code
EARNS_DIST_TYPE     Char      333        1         1    Upper         Earnings Distribution Type
EARNS_DIST_TYPE     Char      334        1         1    Value         Description
EARNS_DIST_TYPE     Char      335        1         1    A             By Amount
EARNS_DIST_TYPE     Char      336        1         1    H             By Hours
EARNS_DIST_TYPE     Char      337        1         1    N             None
EARNS_DIST_TYPE     Char      338        1         1    P             By Percent
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
EMPLOYEE SETUP                                                   JOB                                       REVISED: 08/18/2008



                                         RAW
FIELD NAME           TYPE   START POS   LENGTH   MASK    FORMAT        DESCRIPTION                   KEY
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
DIRECTLY_TIPPED      Char      559         1        1    Value         Description
DIRECTLY_TIPPED      Char      560         1        1    D             Directly Tipped
DIRECTLY_TIPPED      Char      561         1        1    I             Indirectly Tipped
DIRECTLY_TIPPED      Char      562         1        1    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
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




PER_ORG              Char      631        3        3     Upper         Organizational Relationship
EMPLOYEE SETUP                                                  JOB                                              REVISED: 08/18/2008



                                         RAW
FIELD NAME           TYPE   START POS   LENGTH   MASK   FORMAT        DESCRIPTION                          KEY


HR_STATUS            Char      634        1       1     Upper         Status

SUPV_LVL_ID          Char      635        8       8     Upper         Supervisor Level

SETID_SUPV_LVL       Char      643        5       5     Upper         Supervisor Level Setid

POI_TYPE             Char      648        5       5     Upper         Person of Interest Type
AUTO_END_FLG         Char      653        1       1     Upper         Auto End Job
HIRE_DT              Date      654        10     10                   First Start Date
LAST_HIRE_DT         Date      664        10     10                   Last Start Date
TERMINATION_DT       Date      674        10     10                   Termination Date
ASGN_START_DT        Date      684        10     10                   First Assignment Start
LST_ASGN_START_DT    Date      694        10     10                   Last Assignment Start Date
ASGN_END_DT          Date      704        10     10                   Last Assignment Date
LDW_OVR              Char      714        1       1                   Override Last Date Worked
LAST_DATE_WORKED     Date      715        10     10                   Last Date Worked
EXPECTED_RETURN_DT   Date      725        10     10                   Expected Return Date
EXPECTED_END_DATE    Date      735        10     10                   Expected Job End Date
LASTUPDDTTM          DTTM      745        26     26                   Last Update Date/Time
LASTUPDOPRID         Char      771        30     30                   Last Update Userid
FILLER               Char      801       278     278                  Filler
GVT_EFFDT            Date      631        10     10                   Effective Date - YYYYMMDD
GVT_EFFDT_PROPOSED   Date      641        10     10                   Proposed Effective Date - YYYYMMDD
GVT_TRANS_NBR        Nbr       651        1       1                   Transaction #
GVT_TRANS_NBR_SEQ    Nbr       652        1       1                   Sequence
GVT_WIP_STATUS       Char      653        3       3     Upper         Work-in-Progress Status
GVT_STATUS_TYPE      Char      656        3       3     Upper         Status Type
GVT_NOA_CODE         Char      659        3       3     Upper         Nature of Action Code
GVT_LEG_AUTH_1       Char      662        3       3     Upper         Legal Authority (1)
GVT_PAR_AUTH_D1      Char      665        25     25     Mixed         Authority 1 Descr - Part 1
GVT_PAR_AUTH_D1_2    Char      690        25     25     Mixed         Authority 1 Descr - Part 2
GVT_LEG_AUTH_2       Char      715        3       3     Upper         Legal Authority (2)
GVT_PAR_AUTH_D2      Char      718        25     25     Mixed         Authority 2 Descr - Part 1
GVT_PAR_AUTH_D2_2    Char      743        25     25     Mixed         Authority 2 Descr - Part 2
GVT_PAR_NTE_DATE     Date      768        10     10                   Not To Exceed Date - YYYYMMDD
GVT_WORK_SCHED       Char      778        1       1     Upper         Work Schedule
GVT_SUB_AGENCY       Char      779        2       2     Upper         Sub-Agency
GVT_ELIG_FEHB        Char      781        3       3     Upper         Eligible for FEHB
GVT_FEHB_DT          Date      784        10     10                   FEHB Eligibility Date - YYYYMMDD
GVT_PAY_RATE_DETER   Char      794        1       1     Upper         Pay Rate Determinant
GVT_STEP             Char      795        2       2     Upper         US Federal Step
GVT_RTND_PAY_PLAN    Char      797        2       2     Upper         Retained Pay Plan
GVT_RTND_SAL_PLAN    Char      799        4       4     Upper         Retained Pay Table
EMPLOYEE SETUP                                                   JOB                                                REVISED: 08/18/2008



                                         RAW
FIELD NAME           TYPE   START POS   LENGTH   MASK    FORMAT        DESCRIPTION                            KEY
GVT_RTND_GRADE       Char      803         3        3    Upper         Retained Grade
GVT_RTND_STEP        Nbr       806         2        2                  Retained Step
GVT_RTND_GVT_STEP    Char      808         2        2    Upper         Retained US Federal Step
GVT_PAY_BASIS        Char      810         2        2    Upper         Pay Basis
GVT_COMPRATE         Nbr       812        19      12.6                 Base Pay
GVT_LOCALITY_ADJ     Nbr       831         8       5.2                 Locality Adjustment
GVT_BIWEEKLY_RT      Nbr       839        10       7.2                 Biweekly Rate
GVT_DAILY_RT         Nbr       849        10       7.2                 Daily Rate
GVT_HRLY_RT_NO_LOC   Nbr       859        19      12.6                 Hourly Rate with out Location
GVT_DLY_RT_NO_LOC    Nbr       878        10       7.2                 Daily Rate No Locality
GVT_BW_RT_NO_LOC     Nbr       888        10       7.2                 No Locality Biweekly Rate
GVT_MNLY_RT_NO_LOC   Nbr       898        19      15.3                 No Locality Monthly Rate
GVT_ANNL_RT_NO_LOC   Nbr       917        19      15.3                 No Locality Annual Rate
GVT_XFER_FROM_AGCY   Char      936         2        2    Upper         Transferred From Agency
GVT_XFER_TO_AGCY     Char      938         2        2    Upper         Transferred To Agency
GVT_RETIRE_PLAN      Char      940         1        1    Upper         Retirement Plan
GVT_ANN_IND          Char      941         1        1    Upper         Annuitant Indicator
GVT_FEGLI            Char      942         2        2    Upper         FEGLI Code
GVT_FEGLI_LIVING     Char      944         1        1    Upper         FEGLI Living Benefits
GVT_LIVING_AMT       Nbr       945         8        8                  Living Benefit Coverage Amount
GVT_ANNUITY_OFFSET   Nbr       953         8        8                  CSRS Annuity Offset Amount
GVT_CSRS_FROZN_SVC   Char      961         4        4                  CSRS Frozen Service
GVT_PREV_RET_COVRG   Char      965         1        1    Upper         Previous Retirement Coverage
GVT_FERS_COVERAGE    Char      966         1        1    Upper         FERS Coverage
GVT_TYPE_OF_APPT     Char      967         2        2    Upper         Type of Appointment
GVT_POI              Char      969         4        4    Upper         Personnel Office ID
GVT_POSN_OCCUPIED    Char      973         1        1    Upper         Position Occupied
GVT_CONT_EMPLID      Char      974        11       11    Upper         Contact Emplid
GVT_ROUTE_NEXT       Char      985        11       11    Upper         Route to Next
GVT_CHANGE_FLAG      Char      996         1        1    Upper         Change Flag
GVT_TSP_UPD_IND      Char      997         1        1    Upper         TSP Status
GVT_PI_UPD_IND       Char      998         1        1    Upper         pi upd ind
GVT_SF52_NBR         Char      999        10       10    Upper         SF-52 Request Number
GVT_S113G_CEILING    Char      1009        1        1    Upper         SF-113G Ceiling
GVT_LEO_POSITION     Char      1010        1        1    Upper         LEO/Fire Position
GVT_ANNUIT_COM_DT    Date      1011       10       10                  Annuity Commencement Date - YYYYMMDD
GVT_BASIC_LIFE_RED   Char      1021        2        2    Upper         Post 65 Basic Life Reduction
GVT_DED_PRORT_DT     Date      1023       10       10                  4 Day Date - YYYYMMDD
GVT_FEGLI_BASC_PCT   Nbr       1033        8       1.6                 FEGLI Basic Percent
GVT_FEGLI_OPT_PCT    Nbr       1041        8       1.6                 FEGLI Optional Percent
GVT_FEHB_PCT         Nbr       1049        8       1.6                 FEHB %
GVT_RETRO_FLAG       Char      1057        1        1    Upper         Retro Pay Flag
GVT_RETRO_DED_FLAG   Char      1058        1        1    Upper         Retro Ded Flag
GVT_RETRO_JOB_FLAG   Char      1059        1        1    Upper         Retro Job Flag
GVT_RETRO_BSE_FLAG   Char      1060        1        1    Upper         Retro Base Flag
EMPLOYEE SETUP                                                  JOB                                           REVISED: 08/18/2008



                                         RAW
FIELD NAME           TYPE   START POS   LENGTH   MASK   FORMAT        DESCRIPTION                       KEY
GVT_OTH_PAY_CHG      Char      1061        1       1    Upper         Other Pay Change Flag
GVT_DETL_POSN_NBR    Char      1062        8       8    Upper         GVT Detail Position Number
ANNL_BEN_BASE_OVRD   Char      1070        1       1    Upper         Annl Benefit Base Rt Override
BENEFIT_PROGRAM      Char      1071        3       3    Upper         Benefit Program
UPDATE_PAYROLL       Char      1074        1       1    Upper         Update Payroll Flags
GVT_PAY_PLAN         Char      1075        2       2    Upper         Pay Plan
GVT_PAY_FLAG         Char      1077        1       1    Upper         GVT_PAY_FLAG
GVT_NID_CHANGE       Char      1078        1       1    Upper         GVT_NID_CHANGE
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
CLASS_INDC           Char      1214        1       1    Upper         Classified/Unclassified Indc
CLASS_INDC           Char      1215        1       1    Value         Description
CLASS_INDC           Char      1216        1       1    B             All
CLASS_INDC           Char      1217        1       1    C             Classified
CLASS_INDC           Char      1218        1       1    T             Temporary
CLASS_INDC           Char      1219        1       1    U             Unclassified
ENCUMB_OVERRIDE      Char      1215        1       1    Upper         Encumbrance Override
EMPLOYEE SETUP                                                     JOB                                            REVISED: 08/18/2008



                                            RAW
FIELD NAME           TYPE   START POS      LENGTH   MASK   FORMAT          DESCRIPTION                      KEY
FICA_STATUS_EE       Char      1216           1       1    Upper           FICA Status-Employee
FICA_STATUS_EE       Char      1217           1       1    Value           Description
FICA_STATUS_EE       Char      1218           1       1    E               Exempt
FICA_STATUS_EE       Char      1219           1       1    M               Medicare only
FICA_STATUS_EE       Char      1220           1       1    N               Subject
FTE                  Nbr       1217           4      1.2                   FTE
PRORATE_CNT_AMT      Char      1221           1       1    Upper           Prorate Contract Change Amount
PRORATE_CNT_AMT      Char      1222           1       1    Value           Description
PRORATE_CNT_AMT      Char      1223           1       1    C               Prorate Over Contract Period
PRORATE_CNT_AMT      Char      1224           1       1    N               No Proration of Change Amt.
PRORATE_CNT_AMT      Char      1225           1       1    P               Prorate over Payment Period
PAY_SYSTEM_FLG       Char      1222           2       2    Upper           Payroll System
PAY_SYSTEM_FLG       Char      1222           2       2    Value           Description
PAY_SYSTEM_FLG       Char      1222           2       2    GP              Global Payroll
PAY_SYSTEM_FLG       Char      1222           2       2    NA              Payroll for North America
PAY_SYSTEM_FLG       Char      1222           2       2    OT              Other
PAY_SYSTEM_FLG       Char      1222           2       2    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
JOB_INDICATOR        Char      1252           1       1    Value           Description
JOB_INDICATOR        Char      1253           1       1    N               Not Applicable
JOB_INDICATOR        Char      1254           1       1    P               Primary Job
JOB_INDICATOR        Char      1255           1       1    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
BENEFIT_SYSTEM       Char      1293           2       2    Value           Description
BENEFIT_SYSTEM       Char      1295           2       2    BA              Benefits Administration
BENEFIT_SYSTEM       Char      1297           2       2    BN              Base Benefits
WORK_DAY_HOURS       Nbr       1293           7      4.2                   Number of Hours in a Work Day
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
JOB_DATA_SRC_CD      Char      1332           3       3    Value           Description
JOB_DATA_SRC_CD      Char      1335           3       3                  0 User Generated
JOB_DATA_SRC_CD      Char      1338           3       3                  1 Batch Generated
JOB_DATA_SRC_CD      Char      1341           3       3                  2 Staff Movement Generated
ESTABID              Char      1332          12      12    Upper           Establishment ID

                            Total Length    1988
EMPLOYEE SETUP    JOB   REVISED: 08/18/2008




CHANGES FOR 9.0
EMPLOYEE SETUP    JOB   REVISED: 08/18/2008




CHANGES FOR 9.0
EMPLOYEE SETUP                JOB   REVISED: 08/18/2008




CHANGES FOR 9.0




In 9.0 will be blank on Max
Effective Dated Job Row.
Use the Acct_Cd from
Job_Earns_Dist
EMPLOYEE SETUP             JOB   REVISED: 08/18/2008




CHANGES FOR 9.0




** New
 CWR - Contingent worker
 EMP - Employee
POI - Person of Interest
EMPLOYEE SETUP    JOB   REVISED: 08/18/2008




CHANGES FOR 9.0
** New
A - Active
I - Inactive
** New
SUPVR
** New

** New

** New
** New
** New
** New
** New
** New
** New
** New
** New
** New
** New
** New
** New
** New
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
EMPLOYEE SETUP    JOB   REVISED: 08/18/2008




CHANGES FOR 9.0
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
EMPLOYEE SETUP    JOB   REVISED: 08/18/2008




CHANGES FOR 9.0
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
Not Used
EMPLOYEE SETUP    JOB   REVISED: 08/18/2008




CHANGES FOR 9.0
EMPLOYEE SETUP                                                                           JOB_EARNS_DIST                REVISED: 02/06/2004




                                                                                                          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
SHIFT           Char               101          1       1 Value     Description
SHIFT           Char               102          1       1       1                               1
SHIFT           Char               103          1       1       2                               2
SHIFT           Char               104          1       1       3                               3
SHIFT           Char               105          1       1 C         Compressed
SHIFT           Char               106          1       1 N         Not Applicable
SHIFT           Char               107          1       1 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        1350
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
PLAN_TYPE           Value   Description
PLAN_TYPE           0       General Deduction
PLAN_TYPE           10      Medical
PLAN_TYPE           11      Dental
PLAN_TYPE           14      Vision
PLAN_TYPE           1Y      Dental - Dependents
PLAN_TYPE           1Z      Medical - Dependents
PLAN_TYPE           20      Life
PLAN_TYPE           21      Supplemental Life
PLAN_TYPE           25      Dependent Life
PLAN_TYPE           27      Supplemental Life - 1st 20000
PLAN_TYPE           2X      Supp Life > $50,000
PLAN_TYPE           30      Short-Term Disability
PLAN_TYPE           47      Nonelective Contributions
PLAN_TYPE           48      Employer Only
PLAN_TYPE           49      Section 457
PLAN_TYPE           4Y      OPERS
PLAN_TYPE           4Z      Administrative Fee
PLAN_TYPE           50      Sick
PLAN_TYPE           51      Vacation
PLAN_TYPE           60      Flex Spending Health - U.S.
PLAN_TYPE           61      Flex Spending Dependent Care
PLAN_TYPE           70      PERS
PLAN_TYPE           7Y      PERS 3
PLAN_TYPE           7Z      PERS 2
PLAN_TYPE           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
COVERAGE_ELECT      Value   Description
COVERAGE_ELECT      E       Elect
COVERAGE_ELECT      T       Terminate
COVERAGE_ELECT      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
GVT_STAT_CHG_FLAG    Value     Description
GVT_STAT_CHG_FLAG    A         Benefits Administration
GVT_STAT_CHG_FLAG    B         Base Benefits
GVT_STAT_CHG_FLAG    N         Not Applicable
GVT_STAT_CHG_FLAG    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.
PLAN_TYPE           Value   Description
PLAN_TYPE           0       General Deduction
PLAN_TYPE           10      Medical
PLAN_TYPE           11      Dental
PLAN_TYPE           14      Vision
PLAN_TYPE           1Y      Dental - Dependents
PLAN_TYPE           1Z      Medical - Dependents
PLAN_TYPE           20      Life
PLAN_TYPE           21      Supplemental Life
PLAN_TYPE           25      Dependent Life
PLAN_TYPE           27      Supplemental Life - 1st 20000
PLAN_TYPE           2X      Supp Life > $50,000
PLAN_TYPE           30      Short-Term Disability
PLAN_TYPE           47      Nonelective Contributions
PLAN_TYPE           48      Employer Only
PLAN_TYPE           49      Section 457
PLAN_TYPE           4Y      OPERS
PLAN_TYPE           4Z      Administrative Fee
PLAN_TYPE           50      Sick
PLAN_TYPE           51      Vacation
PLAN_TYPE           60      Flex Spending Health - U.S.
PLAN_TYPE           61      Flex Spending Dependent Care
PLAN_TYPE           70      PERS
PLAN_TYPE           7Y      PERS 3
PLAN_TYPE           7Z      PERS 2
PLAN_TYPE           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
COVERAGE_ELECT      Value   Description
COVERAGE_ELECT      E       Elect
COVERAGE_ELECT      T       Terminate
COVERAGE_ELECT      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
SAVINGS_COVRG        Value   Description
SAVINGS_COVRG        1       Flat Amount
SAVINGS_COVRG        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
SAVINGS_COVRG_ATAX   Value   Description
SAVINGS_COVRG_ATAX   1       Flat Amount
SAVINGS_COVRG_ATAX   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
                                            RAW
FIELD NAME           TYPE   START POS       LENG MASK FORMAT    DESCRIPTION                 KEY    TABLE        FIELD       TYPE   LENG   CONVERSION RULE                   ISSUES / Comments
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.
SPECIAL_SWT_STATUS Char                 51     1     1 Value    Description
                                                                Non-Resident Alien; Fed
SPECIAL_SWT_STATUS   Char               52     1     1   A      Rules
SPECIAL_SWT_STATUS   Char               53     1     1   E      Exempt
SPECIAL_SWT_STATUS   Char               54     1     1   G      Maintain gross
SPECIAL_SWT_STATUS   Char               55     1     1   N      None
EMPLOYEE SETUP                                                                                     STATE_TAX_DATA                                                                                            REVISED: 02/06/2004




                                           PEOPLESOFT                                                                     LEGACY
                                            RAW
FIELD NAME         TYPE   START POS         LENG MASK         FORMAT   DESCRIPTION                   KEY    TABLE        FIELD      TYPE      LENG   CONVERSION RULE                   ISSUES / Comments
                                                                                                                                                     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.
WAGE_PLAN_CD       Char               59       1         1    Value    Description
WAGE_PLAN_CD       Char               60       1         1    A        None/State
WAGE_PLAN_CD       Char               61       1         1    J        State/Exempt
WAGE_PLAN_CD       Char               62       1         1    L        Voluntary/Exempt
WAGE_PLAN_CD       Char               63       1         1    P        None/None
WAGE_PLAN_CD       Char               64       1         1    R        DI Exempt/State
WAGE_PLAN_CD       Char               65       1         1    S        State/State
WAGE_PLAN_CD       Char               66       1         1    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.
SDI_STATUS         Char               86       1         1    Value    Description
SDI_STATUS         Char               87       1         1    E        Exempt
SDI_STATUS         Char               88       1         1    N        Not Applicable

SDI_STATUS         Char               89       1         1 V           Voluntary Disability Plan
SDI_STATUS         Char               90       1         1 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
                                               RAW
FIELD NAME        TYPE       START POS         LENG MASK       FORMAT   DESCRIPTION                 KEY   TABLE    FIELD     TYPE   LENG   CONVERSION RULE               ISSUES / Comments
                                                                                                                                                                         Situation One: The employee lives
                                                                                                                                                                         (and presumably works) in
                                                                                                                                                                         Oklahoma. Set this field to "Y".
                                                                                                                                           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.
ADDL_AMT_ADJ      Char                   89       1        1 Value      Description
                                                                        Decrease Additional
ADDL_AMT_ADJ      Char                   90       1        1 D          Amount
                                                                        Increase Additional
ADDL_AMT_ADJ      Char                   91       1        1 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          1364
EMPLOYEE SETUP   STATE_TAX_DATA   REVISED: 02/06/2004




 NO CHANGES
   FOR 9.0
EMPLOYEE SETUP   STATE_TAX_DATA   REVISED: 02/06/2004




 NO CHANGES
   FOR 9.0
EMPLOYEE SETUP   STATE_TAX_DATA   REVISED: 02/06/2004




 NO CHANGES
   FOR 9.0
EMPLOYEE SETUP TABLES                           COMPENSATION                                              REVISED: 05/07/2004


                                                                                                                     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
CMP_SRC_IND        Char              130            1            1   Value  Description
CMP_SRC_IND        Char              130            1            1     A    Absorbing Premium
CMP_SRC_IND        Char              130            1            1     B    Non-Absorbing Premium
CMP_SRC_IND        Char              130            1            1     C    Combination Rule
CMP_SRC_IND        Char              130            1            1     E    Seniority Pay
CMP_SRC_IND        Char              130            1            1     J    Job Code
CMP_SRC_IND        Char              130            1            1     M    Manual
CMP_SRC_IND        Char              130            1            1     N    None
CMP_SRC_IND        Char              130            1            1     P    Payroll
CMP_SRC_IND        Char              130            1            1     R    Employee Review
CMP_SRC_IND        Char              130            1            1     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             1354
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
FIELD NAME          TYPE   START POS            RAW LENGTH          MASK   FORMAT   DESCRIPTION               KEY

RECORD NAME         Char                   1                    8          Upper    Value:SCHASGN
SSN                 Char                   9                    9          Upper    Soc Sec Nbr
EMPLID              Char                  18                   11          Upper    EmplID                   K
EMPL_RCD            Nbr                   29                    3                   Empl Rcd Nbr             K
EFFDT               Date                  32                   10                   Effective Date           K
END_EFFDT           Date                  42                   10                   End Effdt
SCHEDULE_GRP        Char                  52                   10          Upper    Schedule Group
SETID               Char                  62                    5          Upper    SetID
SCH_ADHOC_IND       Char                  67                    1          Upper    Ad Hoc Schedule
                                                                                    Indicator
SCHEDULE_ID         Char                  68                   16          Upper    Schedule ID
ROTATION_ID         Char                  84                   10          Upper    Rotation ID
USE_DFLT_WS         Char                  94                    1          Upper    Assignment Method
ALT_SCHEDULE_GRP    Char                  95                   10          Upper    Alternate Schedule Group

SETID_SCHED         Char                105                     5          Upper    Schedule SetID
SCH_ADHOC_IND_ALT   Char               1110                     1          Upper    Ad Hoc Schedule
                                                                                    Indicator
ALT-WRK_SCHED_ID    Char                  111                  16          Upper    Alternate Work Schedule

ROTATION_ID_ALT     Char                  127                  10          Upper    Alternate Rotation ID
USE_ALT_DFLT_WS     Char                  137                   1          Upper    Assignment Method
Filler              Char                  138                1206                   space

                           Total Length                      1343
FIELD NAME       TYPE   START POS        RAW LENGTH          MASK   FORMAT   DESCRIPTION              KEY

RECORD NAME      Char                1                   8          Upper    Value:TLEMPCOM
SSN              C                   9                   9                   Soc Sec Nbr
EMPLID           Char               18                  11          Upper    EmplID                   K
EMPL_RCD         Nbr                29                   3                   Empl Rcd Nbr             K
EFFDT            Date               32                  10                   Effective Date           K
COMP_TIME_PLAN   Char               42                  10          Upper    Compensatory Time Off    K
                                                                             Plan
EFF_STATUS       Char               52                   1          Upper    Status as of Effective
                                                                             Date
Filler           Char               53                1291                   space

                        Total Length                  1343
FIELD NAME            TYPE   START POS            RAW        MASK   FORMAT   DESCRIPTION                  KEY
                                                  LENGTH
RECORD NAME           Char                    1          8          Upper    Value:TLEMPDAT
SSN                   Char                    9          9                   Soc Sec Nbr
EMPLID                Char                   18         11          Upper    EmplID                       K
EMPL_RCD              Nbr                    29          3                   Empl Rcd Nbr                 K
EFFDT                 Date                   32         10                   Effective Date               K
TIME_RPTG_STATUS      Char                   42          1          Upper    Time Reporter Status
TIME_RPTR_IND         Char                   43          1          Upper    Time Reporter Indicator
ELP_TR_TMPLT_IND      Char                   44         10          Upper    Elapsed Reporting Template
PCH_TR_TMPLT_ID       Char                   54         10          Upper    Punch Reporting Template
PERIOD_ID             Char                   64         12          Upper    Time Period ID
WORKGROUP             Char                   76         10          Upper    Workgroup
TASKGROUP             Char                   86         10          Upper    Taskgroup
TASK_PROFILE_ID       Char                   96         10          Upper    Task Profile ID
TCD_GROUP_ID          Char                  106         10          Upper    TCD Group ID
RESTRICTION_PRF_IND   Char                  116         10          Upper    Restriction Profile ID
TTIME_TO_PAY          Char                  126          1          Upper    Send Time to Payroll
RULE_ELEMENT_1        Char                  127         10          Upper    Rule Element 1
RULE_ELEMENT_2        Char                  137         10          Upper    Rule Element 2
RULE_ELEMENT_3        Char                  147         10          Upper    Rule Element 3
RULE_ELEMENT_4        Char                  157         10          Upper    Rule Element 4
RULE_ELEMENT_5        Char                  167         10          Upper    Rule Element 5
TIMEZONE              Char                  177          9          Upper    Time Zone
Filler                Char                  186       1158                   space

                             Total Length             1343

								
To top