GPCH_AL_EMPLMT

(SQL Table)
Index Back

EE Employment Data

EMPLOYMENT is one of the core records in the database. Use it to record an employee's employment-related data that doesn't tend to change, such as hire date, termination date, and company service date.

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: PERSON.EMPLID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    5 GPCH_AL_AL01_PRINT Character(1) VARCHAR2(1) NOT NULL Print Pay Slip

    Y/N Table Edit

    Default Value: N

    6 GPCH_AL_AL01_ADDR Character(2) VARCHAR2(2) NOT NULL Pay Slip Postal Address
    01=Personal Address
    02=Location Address
    7 GPCH_BEG_NTCE_TRM Date(10) DATE Termination Date
    8 GPCH_BK_NEG_FW Character(1) VARCHAR2(1) NOT NULL Forward Negative Payments
    0=Do not carry over negative pay
    1=Carry over negative pay
    9 GPCH_RP_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print LAW

    Y/N Table Edit

    Default Value: Y

    10 GPCH_TX_LAW_SW Character(1) VARCHAR2(1) NOT NULL Tax Law

    Y/N Table Edit

    Default Value: N

    11 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

    Default Value: HOME

    Prompt Table: ADDRESS_TYP_TBL