PY_LDTLCD_TBVW0(SQL View) |
Index Back |
|---|---|
Load Time & Labor EarningsLoad Time & Labor Earnings Codes (Filters) |
| SELECT PAY_SYSTEM ,PAYROLL_REQ_NUM , PY_LDTL_SEPCHK_GRP , ERNCD , PPA_IND FROM PS_PY_LDTLCD_TBL WHERE PY_LDTL_SEPCHK_GRP = '0' |
| # | 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=Payroll for North America |
| 2 | PAYROLL_REQ_NUM |
Number(6,0) | INTEGER NOT NULL |
Last payroll request number.
Prompt Table: PY_LDTL_TBL |
| 3 | PY_LDTL_SEPCHK_GRP |
Character(1) | VARCHAR2(1) NOT NULL |
Separate Check Group Code
0=Filter Source 1=Separate Check Grouping 1 2=Separate Check Grouping 2 3=Separate Check Grouping 3 Default Value: 0 |
| 4 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: EARNINGS_TBL |
| 5 | PPA_IND | Character(1) | VARCHAR2(1) NOT NULL |
Prior Period Adjustments Only
Y/N Table Edit Default Value: N |