EMPLIDDefault Value: PERSON.EMPLID
Prompt Table: PERSON
EMPL_RCDY/N Table Edit
Default Value: Y
01=Personal Address
02=Location Address
N=Show Unchanged Retro
Y=Suppress Unchanged Retro
Default Value: Y
GPDE_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 | GPDE_AL_AL01_PRINT | Character(1) | VARCHAR2(1) NOT NULL |
Pay Slip Print
Y/N Table Edit Default Value: Y |
| 4 | GPDE_AL_AL01_ADDR | Character(2) | VARCHAR2(2) NOT NULL |
Pay Slip Address
01=Personal Address 02=Location Address |
| 5 | GPDE_BEG_NTCE_TRM | Date(10) | DATE | Termination Date |
| 6 | GPDE_RETRO_DISP | Character(1) | VARCHAR2(1) NOT NULL |
retro display flag. Set to N if unchanged retros should not be suppressed on reports. Y (default) if all retro rows should be printed.
N=Show Unchanged Retro Y=Suppress Unchanged Retro Default Value: Y |