PIN_NUMGP_PIN_USER_FLD(SQL Table) |
Index Back |
|---|---|
User Fields Names/Big StuffElement Names for the User Fields used by Big Stuff and Accumulators. This record is provided by GP Core for EPM. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | PIN_USER_FLD1_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 3 | PIN_USER_FLD2_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 4 | PIN_USER_FLD3_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 5 | PIN_USER_FLD4_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 6 | PIN_USER_FLD5_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 7 | PIN_USER_FLD6_NUM | Number(8,0) | INTEGER NOT NULL | User Field 6 |
| 8 | PIN_USER_FLD1_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 9 | PIN_USER_FLD2_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 10 | PIN_USER_FLD3_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 11 | PIN_USER_FLD4_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 12 | PIN_USER_FLD5_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 13 | PIN_USER_FLD6_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |