TRW_DTL_COL_VW(SQL View) |
Index Back |
---|---|
Reward Item Detail ColumnsGets the output columns for a reward item to display in the reward item details page. |
SELECT RI.TRW_RW_ITEM_ID , RI.TRW_DATASRC_ID , RIF.FIELDNAME , RI.EFFDT , 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 , RIF.TRW_DISPLAY_SW FROM PS_TRW_RW_ITEM RI , PS_TRW_RW_ITEM_FLD RIF , PS_TRW_DATASRC_RIO DSRC , PSDBFIELD PSFLD WHERE RI.EFF_STATUS = 'A' AND RI.TRW_RW_ITEM_ID = RIF.TRW_RW_ITEM_ID AND RIF.EFFDT = RI.EFFDT AND RI.TRW_DATASRC_ID = DSRC.TRW_DATASRC_ID AND RIF.FIELDNAME = DSRC.FIELDNAME AND PSFLD.FIELDNAME = RIF.FIELDNAME |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TRW_RW_ITEM_ID | Character(15) | VARCHAR2(15) NOT NULL | Total rewards statement - reward item ID |
2 | TRW_DATASRC_ID | Character(15) | VARCHAR2(15) NOT NULL | Total rewards statement - Reward Data Source ID |
3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
5 | 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 |
6 | TRW_DTL_DESCR_TBL | Character(15) | VARCHAR2(15) NOT NULL | Total Rewards Statement - Detail Description Table |
7 | TRW_DTL_DESCR_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Total Rewards Statement - Detail Description Field
Prompt Table: TRW_RIO_FLD_VW |
8 | TRW_DTL_COL_LBL | Character(30) | VARCHAR2(30) NOT NULL | Total Rewards Statement - Detail Grid Column Label |
9 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
10 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
11 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
12 | TRW_DISPLAY_SW | Character(1) | VARCHAR2(1) NOT NULL |
Always display checkbox for reward item setup.
Y/N Table Edit Default Value: N |