GPBR_IDCAL2_VW

(SQL View)
 Index Back

Temporary S-1200 for eSocial

Temporary S-1200 for eSocial View

SELECT A.GPBR_ESOC_YEAR ,A.GPBR_ESOC_MONTHCD ,A.COMPANY ,A.GP_PAYGROUP ,A.CAL_RUN_ID ,A.CAL_ID ,A.EMPLID ,A.GPBR_CPF_ID ,A.EMPL_RCD ,A.RUN_TYPE ,A.PAYMENT_DT ,A.PYE_CALC_STAT ,A.RUN_FINALIZED_IND ,A.GPBR_1200_STATUS ,A.GPBR_1210_STATUS FROM PS_GPBR_ES_IDCAL A WHERE (A.GPBR_EVENT_1200='Y' OR A.GPBR_EVENT_1210='Y')

  • Parent record: GPBR_ES_PER_RC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_ESOC_YEAR Number(4,0) SMALLINT NOT NULL Competency Year
    2 GPBR_ESOC_MONTHCD Character(2) VARCHAR2(2) NOT NULL eSocial Competency Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 GPBR_CPF_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
    9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    10 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
    11 PAYMENT_DT Date(10) DATE Payment Date
    12 PYE_CALC_STAT Character(2) VARCHAR2(2) NOT NULL Calculation Status: field indicates the processing status of a segment (payment)
    00=Identified
    02=Calculation Error
    03=Calculation Error - Bypassed
    04=Calculation Error - By Rule
    11=No Segment Created
    50=Calculation Successful
    55=Frozen For Further Calc
    70=Finalized
    75=Finalized - With Banking
    13 RUN_FINALIZED_IND Character(1) VARCHAR2(1) NOT NULL Finalized Run
    14 GPBR_1200_STATUS Character(4) VARCHAR2(4) NOT NULL 1200 Status
    AFC=Awaiting Finalize Calendar
    ARG=Awaiting Return Government
    ART=Awaiting Return Termination
    ERRE=Error Event
    FIN=Finalized
    IDEN=Identified
    MSET=Not Eligible
    NCOM=Next Competency
    PCOM=Previous Competency
    STE=Termination in Progress
    15 GPBR_1210_STATUS Character(4) VARCHAR2(4) NOT NULL 1210 Status
    AFC=Awaiting Finalize Calendar
    ARG=Awaiting Return Government
    ART=Awaiting Return Termination
    ERRE=Error Event
    FIN=Finalized
    IDEN=Identified
    MSET=Not Eligible
    NCOM=Next Competency
    PCOM=Previous Competency
    STE=Termination in Progress