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 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 |