GPIT_RP_WA_KEYS

(SQL Table)
Index Back

Record to store WA Keys

Record to store the WA Key sets that are useful for the report.

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
    8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
    9 SLICE_END_DT Date(10) DATE NOT NULL Element Slice End Date
    10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    11 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    12 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
    13 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    14 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    15 INAIL_CODE Character(11) VARCHAR2(11) NOT NULL INAIL Code
    16 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    18 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    19 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
    20 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
    21 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory