PIN_NUMGP_NRP_PUFLD_VW(SQL View) |
Index Back |
|---|---|
Packager View for User FieldsPackager view for Pin User Fields. Element Names for the User Fields used by Big Stuff and Accumulators. This record is provided by GP Core for EPM. |
| SELECT PIN_NUM + 50000000 ,PIN_USER_FLD1_NUM + 50000000 ,PIN_USER_FLD2_NUM + 50000000 ,PIN_USER_FLD3_NUM + 50000000 ,PIN_USER_FLD4_NUM + 50000000 ,PIN_USER_FLD5_NUM + 50000000 ,PIN_USER_FLD6_NUM + 50000000 ,PIN_USER_FLD1_NM ,PIN_USER_FLD2_NM ,PIN_USER_FLD3_NM ,PIN_USER_FLD4_NM ,PIN_USER_FLD5_NM ,PIN_USER_FLD6_NM FROM PS_GP_PIN_USER_FLD |
| # | 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 | Pin Number |
| 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 |