PTAI_LIST_IDFIELDNAMERECNAMELANGUAGE_CDGDP_CTX_SEQ_LVW(SQL View) |
Index Back |
|---|---|
GDP Context Data Lang ViewGuided Process Context Data Language View |
| SELECT LST.PTAI_LIST_ID , CTX.FIELDNAME , CTX.RECNAME , GLCTX.LANGUAGE_CD , GLCTX.GDP_KEY_LABEL FROM PS_PTAI_LIST LST , PS_PTAI_CONTEXT CTX , PS_GDP_TMPL_TBL GTBL , PS_GDP_TMPL_CTX GCTX , PS_GDP_CTX_LNG GLCTX WHERE LST.PTAI_LIST_ID = CTX.PTAI_LIST_ID AND LST.PTAI_PARENT_TMPL = GTBL.GDP_LIST_ID AND GTBL.GDP_TEMPLATE_ID = GCTX.GDP_TEMPLATE_ID AND CTX.RECNAME = GCTX.RECNAME AND CTX.FIELDNAME = GCTX.FIELDNAME AND GCTX.GDP_TEMPLATE_ID = GLCTX.GDP_TEMPLATE_ID AND GCTX.RECNAME = GLCTX.RECNAME AND GCTX.FIELDNAME = GLCTX.FIELDNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAI_LIST_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | PTAI_KEY_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Label |