TRCEFFDTDefault Value: %date
SP_PAY_TYPESPA_TRC_PT_VW(SQL View) |
Index Back |
|---|---|
Invoice TRC Pay TypesThis view fetches details for the Pay Types break up for a TRC |
| SELECT T.TRC ,T.EFFDT ,T.SP_PAY_TYPE ,T.SP_PAY_TYPE_MULT FROM PS_SPA_TRC_PAYTYPE T |
| # | 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 |
Effective Date
Default Value: %date |
| 3 | SP_PAY_TYPE |
Character(18) | VARCHAR2(18) NOT NULL | Pay Types for Supplier Rate Breakdown |
| 4 | SP_PAY_TYPE_MULT | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | Pay Type Multiplication Factor |