FIELDNAMEPrompt Table: GP_PIN
GPFR_ES_ABSNMVW(SQL View) |
Index Back |
|---|---|
Absence WA Field Element ViewAbsence WA Field Element Name View |
| SELECT WF.FIELDNAME , N.PIN_NM FROM PS_GP_WA_ARRAY WA , PS_GP_WA_FLD WF , PS_GP_PIN_NM_VW N WHERE WA.RECNAME = 'GPFR_ES_ABS_WA' AND WA.PIN_NUM = WF.PIN_NUM AND N.PIN_NUM = WF.PIN_ELEM_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL |
Element Name field
Prompt Table: GP_PIN |