PRCS_TYPEF=Field Level
R=Record Level
PI_PROCESS_IDLANGUAGE_CDPI_PROC_LANG_VW(SQL View) |
Index Back |
|---|---|
Distnct vw pi_procs_tbl-LangSelective view of PI_PROCESS_TBL to show a distinct list of the available Process IDs by type (Record or Field) for related language |
| select DISTINCT T. PRCS_TYPE, L.PI_PROCESS_ID, L.LANGUAGE_CD, L.DESCRSHORT FROM PS_PI_PROC_TB_LANG L, PS_PI_PROCESS_TBL T WHERE L.PI_PROCESS_ID = T.PI_PROCESS_ID AND L.PI_PROCESS_PHASE = T.PI_PROCESS_PHASE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCS_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Process Type
F=Field Level R=Record Level |
| 2 | PI_PROCESS_ID |
Character(6) | VARCHAR2(6) NOT NULL | PI Process ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |