PIN_NUMSEQ_NUM5Prompt Table: %GP_EDIT_FLD4
GPSC_ELM_AR_PR(SQL View) |
Index Back |
|---|---|
Array Formulas RecordGlobal Payroll Array Formulas Record |
| SELECT PIN_NUM , SEQ_NUM5 , PIN_FRML_NUM FROM PS_GP_ARRAY_PRC WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , SEQ_NUM5 , PIN_FRML_NUM FROM PS_GPSC_RM_AR_PRC WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | SEQ_NUM5 |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | PIN_FRML_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: %GP_EDIT_FLD4 |