SETIDFO_TEMPLATE_TYPETEMPLATE_CODESEQUENCE_NBRFO_EMPREF_DTLVW(SQL View) |
Index Back |
|---|
| SELECT SETID ,FO_TEMPLATE_TYPE ,TEMPLATE_CODE ,SEQUENCE_NBR ,TEMPLATE_ITEM_CD FROM PS_FO_TEMPLATE_TBL WHERE EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_FO_TEMPLATE_TBL B WHERE B.SETID = PS_FO_TEMPLATE_TBL.SETID AND B.FO_TEMPLATE_TYPE = PS_FO_TEMPLATE_TBL.FO_TEMPLATE_TYPE AND B.TEMPLATE_CODE = PS_FO_TEMPLATE_TBL.TEMPLATE_CODE AND B.EFFDT <=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | FO_TEMPLATE_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Form Type |
| 3 | TEMPLATE_CODE |
Character(6) | VARCHAR2(6) NOT NULL | Form Code |
| 4 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | TEMPLATE_ITEM_CD | Character(6) | VARCHAR2(6) NOT NULL | Form Item |