SETIDFO_TEMPLATE_TYPETEMPLATE_CODETEMPLATE_ITEM_CDFO_TEMPL_TBL_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.FO_TEMPLATE_TYPE , A.TEMPLATE_CODE , A.TEMPLATE_ITEM_CD , A.SEQUENCE_NBR FROM %Table(FO_TEMPLATE_TBL) A WHERE %EffdtCheck(FO_TEMPLATE_TBL B, A, %currentdatein) AND A.EFF_STATUS = 'A' |
| # | 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 | TEMPLATE_ITEM_CD |
Character(6) | VARCHAR2(6) NOT NULL | Form Item |
| 5 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |