TRC_PROGRAMEFFDTDefault Value: %date
TL_TRC_PGM_VW(SQL View) |
Index Back |
|---|---|
TRC Program TableA TRC Program is a collection of Time Reporting Codes (TRCs), which fit the Time Reporting and Compensation requirements of one or more groups of time reporters. The TRC Program Table maintains the definition of the program, while the assignment of the TRCs to the program is maintained in the TRC Program Element table (TL_TRCPGELE_TBL). |
| SELECT A.TRC_PROGRAM , A.EFFDT , A.DESCR ,A.DESCRSHORT FROM PS_TL_TRC_PGM_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_TL_TRC_PGM_TBL B WHERE A.TRC_PROGRAM = B.TRC_PROGRAM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRC_PROGRAM |
Character(5) | VARCHAR2(5) NOT NULL | TRC Program ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |