TRC_SUM_CATEGORYTL_TRCSUM_RT_VW(SQL View) |
Index Back |
|---|---|
TRC Summary ViewThis View lists the distinct TRC Summary Categories that exist across the active TRC records. |
| SELECT A.TRC_SUM_CATEGORY , A.DESCR , A.DESCRSHORT ,A.RTA_DISPLAY ,A.PTA_DISPLAY FROM PS_TL_TRC_CAT_TBL A WHERE A.RTA_DISPLAY = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRC_SUM_CATEGORY |
Character(6) | VARCHAR2(6) NOT NULL | TRC Category |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | RTA_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL | Reported Time Approval Display |
| 5 | PTA_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL | Payable Time Approval Display |