GPIT_RP_001_HST

(SQL Table)
 Index Back

WA Main Reporting Record

This is the Archive (shadow) table used in Data Archiving for the record: GPIT_RP_0001.

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
    9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
    10 SLICE_END_DT Date(10) DATE Element Slice End Date
    11 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    12 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
    13 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
    14 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
    15 PRD_END_DT Date(10) DATE Pay Period End Date
    16 GPIT_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
    17 PRD_BGN_DT Date(10) DATE Period Begin Date
    18 PYMT_DT Date(10) DATE Payment Date
    19 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    20 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    21 COMP_CODE_ITA Character(30) VARCHAR2(30) NOT NULL Company Codes ITA
    22 INAIL_CODE Character(11) VARCHAR2(11) NOT NULL INAIL Code
    23 INPS_CODE_ITA Character(12) VARCHAR2(12) NOT NULL INPS Code ITA
    24 INPDAI_CODE_ITA Character(16) VARCHAR2(16) NOT NULL INPDAI Code ITA
    25 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    26 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    27 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    28 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    29 REASON Character(30) VARCHAR2(30) NOT NULL Reason
    30 NAME Character(50) VARCHAR2(50) NOT NULL Name
    31 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    32 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    33 MATRICULA_NBR_ITA Number(6,0) INTEGER NOT NULL Matricula Number ITA
    34 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    35 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    36 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    37 STEP Number(2,0) SMALLINT NOT NULL Step
    38 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
    39 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    40 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    41 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
    42 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory
    43 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
    44 JOB_ENTRY_DT Date(10) DATE Job Entry Date
    45 HIRE_DT Date(10) DATE First Start Date
    46 TERMINATION_DT Date(10) DATE Termination Date
    47 GPIT_NEXT_SEN_INCR Date(10) DATE Next seniority increase date for reports
    48 BIRTHDATE Date(10) DATE Date of Birth
    49 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    50 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    51 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    52 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    53 NATIONALITY_CD Character(3) VARCHAR2(3) NOT NULL Nationality Code
    54 NATIONALITY Character(30) VARCHAR2(30) NOT NULL Nationality
    55 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    56 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    57 GPIT_GG_INPS Number(2,0) SMALLINT NOT NULL INPS days for reports
    58 GPIT_SETT_INPS Number(1,0) SMALLINT NOT NULL INPS weeks for reports
    59 PART_TIME_PERC_ITA Number(8,4) DECIMAL(7,4) NOT NULL Percentage of Part Time
    60 GPIT_ANF_TABLE Character(3) VARCHAR2(3) NOT NULL Inps Table Number
    61 GPIT_ANF_COMP Number(2,0) SMALLINT NOT NULL ANF family component for reports
    62 GPIT_ANF_CLASS Number(2,0) SMALLINT NOT NULL ANF class for reports
    63 GPIT_PAYMENT_METH Character(18) VARCHAR2(18) NOT NULL Payment method for reports
    64 GPIT_BANK_ABI Character(5) VARCHAR2(5) NOT NULL ABI code for reports
    65 GPIT_BANK_CAB Character(5) VARCHAR2(5) NOT NULL CAB code for reports
    66 GPIT_CUD_CITY Character(30) VARCHAR2(30) NOT NULL City for CUD
    67 GPIT_CUD_STATE Character(6) VARCHAR2(6) NOT NULL State for CUD
    68 GPIT_CUD_FISCOK Number(1,0) SMALLINT NOT NULL Fiscal part of CUD
    69 GPIT_CUD_PREVOK Number(1,0) SMALLINT NOT NULL Contribution part for CUD
    70 GPIT_INPS_CAT_ID Character(1) VARCHAR2(1) NOT NULL INPS Category
    71 GPIT_CUD_TIPOPT Character(1) VARCHAR2(1) NOT NULL Part time code for CUD
    72 GPIT_CUD_TIPORAPP Character(1) VARCHAR2(1) NOT NULL Regular/temporary employees for CUD
    73 GPIT_INPS_CDCTR_ID Character(2) VARCHAR2(2) NOT NULL INPS Contribution Code
    74 GPIT_INPS_ASSCOP Number(2,0) SMALLINT NOT NULL Useful insurances
    75 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
    76 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    77 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State
    78 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
    79 GPIT_PYSL_DATEH1 Date(10) DATE dummy date
    80 GPIT_PYSL_CHARH1 Character(20) VARCHAR2(20) NOT NULL Dummy character
    81 GPIT_PYSL_AMTH8 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    82 GPIT_PYSL_AMTH9 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    83 GPIT_CITY_CODE Character(4) VARCHAR2(4) NOT NULL City code payee
    84 GPIT_TYPE_1_HIR Character(2) VARCHAR2(2) NOT NULL Type
    85 GPIT_TYPE_2_TER Character(2) VARCHAR2(2) NOT NULL Type
    86 GPIT_AMOUNT_N9 Number(9,0) DECIMAL(9) NOT NULL Amount
    87 GPIT_WEEK1 Number(2,0) SMALLINT NOT NULL Week
    88 GPIT_WEEK2 Number(2,0) SMALLINT NOT NULL Week