PROCESS_INSTANCECOUNTRYGP_ELN_SETPIN_ELEM_GRP_NUMGP_ELN_TMP(SQL Table) |
Index Back |
|---|---|
Element List TemporaryElement List Temporary |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | GP_ELN_SET |
Character(15) | VARCHAR2(15) NOT NULL | Element Set |
| 4 | PIN_ELEM_GRP_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number for Element Group |
| 5 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 6 | GP_ORDER | Number(3,0) | SMALLINT NOT NULL | Utility field for data ordering |
| 7 | GP_ELN_SET_ATTR1 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 8 | GP_ELN_SET_ATTR2 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 9 | GP_ELN_SET_ATTR3 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 10 | GP_ELN_SET_ATTR4 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 11 | GP_ELN_SET_ATTR5 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 12 | GP_ELN_SET_ATTR6 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 13 | GP_ELN_SET_ATTR7 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 14 | GP_ELN_SET_ATTR8 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 15 | GP_ELN_SET_ATTR9 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 16 | GP_ELN_SET_ATTR10 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 17 | GP_ELN_LST_ATTR1 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 18 | GP_ELN_LST_ATTR2 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 19 | GP_ELN_LST_ATTR3 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 20 | GP_ELN_LST_ATTR4 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 21 | GP_ELN_LST_ATTR5 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 22 | GP_ELN_LST_ATTR6 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 23 | GP_ELN_LST_ATTR7 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 24 | GP_ELN_LST_ATTR8 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 25 | GP_ELN_LST_ATTR9 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 26 | GP_ELN_LST_ATTR10 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 27 | GP_ELN_PIN_ATTR1 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 28 | GP_ELN_PIN_ATTR2 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 29 | GP_ELN_PIN_ATTR3 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 30 | GP_ELN_PIN_ATTR4 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 31 | GP_ELN_PIN_ATTR5 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 32 | GP_ELN_PIN_ATTR6 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 33 | GP_ELN_PIN_ATTR7 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 34 | GP_ELN_PIN_ATTR8 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 35 | GP_ELN_PIN_ATTR9 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 36 | GP_ELN_PIN_ATTR10 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |