GPCH_AL_EMPLMT(SQL Table) |
Index Back |
|---|---|
EE Employment DataEMPLOYMENT 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. |
| # | 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 Rcd Nbr |
| 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 |