PSHUP_PROG_DEFN

(SQL Table)
Index Back

PSHUP Inactive Employees Prog

This record is used to define the Paysheet Update Inactive Employees Program.

  • Related Language Record: PSHUPPRDEF_LANG
  • Parent Record Of PSHUP_COS_DEF PSHUP_DEDS_DEF PSHUP_EMPST_DEF PSHUP_ERNS_DEF PSHUP_SRC_DEF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSHUP_PROG_ID Character(3) VARCHAR2(3) NOT NULL Paysheet Update for Inactive Employees Program Id.
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 PY_ALL_SOURCES Character(1) VARCHAR2(1) NOT NULL All Paysheet Update Sources Indicator.

    Y/N Table Edit

    Default Value: N

    7 PY_ALL_EARNS Character(1) VARCHAR2(1) NOT NULL All Earning Codes Indicator for Paysheet Update for Inactive Employess processing.

    Y/N Table Edit

    Default Value: N

    8 PY_ALL_DEDS Character(1) VARCHAR2(1) NOT NULL All Deductions Indicator for Paysheet Update Inactive Employees Program,

    Y/N Table Edit

    Default Value: N

    9 PY_ALL_COS Character(1) VARCHAR2(1) NOT NULL All Companies and Paygropus Indicator for Paysheet Update Inactive Employees Program.

    Y/N Table Edit

    Default Value: N