GPSG_PS_ABS_LNG

(SQL Table)
Index Back

GPSG - Payslip Abs Def

GP Singapore - Payslip absence definition record

  • Related Language Record for GPSG_NRP_PS1_VW GPSG_PSLP_ABS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPSG_PAYSLIP_ID Character(18) VARCHAR2(18) NOT NULL Defines the payslip template ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 GPSG_ENTL_PIN_NUM Number(8,0) INTEGER NOT NULL Element name for Pin Number to hold Absence Entitlement

    Prompt Table: GPSG_ABS_ENT_VW

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description