PAY_SYSTEMGP=Global Payroll
NA=North American Payroll
PAYROLL_REQ_NUMPrompt Table: PY_LDTL_TBL
EMPLIDPrompt Table: PERSON
EMPL_RCDPrompt Table: PER_ORG_ASGN_VW
PY_LDTLEMP_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_SYSTEM |
Character(4) | VARCHAR2(4) NOT NULL |
Payroll System
GP=Global Payroll NA=North American Payroll |
| 2 | PAYROLL_REQ_NUM |
Number(6,0) | INTEGER NOT NULL |
Last payroll request number.
Prompt Table: PY_LDTL_TBL |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: PER_ORG_ASGN_VW |