GPSG_NRP_PSA_AD

(SQL Table)
Index Back

GPSG - Payslip Abs Def

GP Singapore - Payslip absence definition record

  • Related Language Record for GPSG_NRP_PS1_AD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
    2 GPSG_PAYSLIP_ID Character(18) VARCHAR2(18) NOT NULL Defines the payslip template ID
    3 EFFDT Date(10) DATE Effective Date
    4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    5 GPSG_ENTL_PIN_NUM Number(8,0) INTEGER NOT NULL Element name for Pin Number to hold Absence Entitlement
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description