TRCEFFDTDefault Value: %date
SP_PAY_TYPEPrompt Table: SPB_PAYTYPES_VW
SPA_TRC_PAYTYPE(SQL Table) |
Index Back |
|---|---|
TRC's by Pay TypeTRC's by Pay Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRC |
Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | SP_PAY_TYPE |
Character(18) | VARCHAR2(18) NOT NULL |
Pay Types for Supplier Rate Breakdown
Prompt Table: SPB_PAYTYPES_VW |
| 4 | SP_PAY_TYPE_MULT | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | Pay Type Multiplication Factor |