TRW_DTL_REL_VW(SQL View) |
Index Back |
|---|---|
Data Source Detail Rel ColumnsGets the related or additional keys needed for detail descriptions. |
| SELECT DSRC.TRW_DATASRC_ID , DSRC.FIELDNAME , DSRC.TRW_DTL_OUT_COL , DSRC.TRW_DTL_DESCR_TBL , DSRC.TRW_DTL_DESCR_FLD , DSRC.TRW_DTL_COL_LBL , PSFLD.FIELDTYPE , PSFLD.LENGTH , PSFLD.DECIMALPOS FROM PS_TRW_DATASRC_RIO DSRC , PSDBFIELD PSFLD WHERE DSRC.FIELDNAME = PSFLD.FIELDNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TRW_DATASRC_ID |
Character(15) | VARCHAR2(15) NOT NULL | Total rewards statement - Reward Data Source ID |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | TRW_DTL_OUT_COL | Character(3) | VARCHAR2(3) NOT NULL |
Total Rewards Statement - Detail Output Column
A01=Detail Date A05=Detail Data 1 A10=Detail Data 2 A15=Detail Data 3 A20=Detail Data 4 A25=Detail Data 5 D01=Employee Paid D05=Employer Paid D10=Company Provided G01=Units G05=Unit of Measure G10=Rate Per Unit J01=Related Detail Data 1 J05=Related Detail Data 2 J10=Related Detail Data 3 |
| 4 | TRW_DTL_DESCR_TBL | Character(15) | VARCHAR2(15) NOT NULL | Total Rewards Statement - Detail Description Table |
| 5 | TRW_DTL_DESCR_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Total Rewards Statement - Detail Description Field
Prompt Table: TRW_RIO_FLD_VW |
| 6 | TRW_DTL_COL_LBL | Character(30) | VARCHAR2(30) NOT NULL | Total Rewards Statement - Detail Grid Column Label |
| 7 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 8 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 9 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |