GPSC_ELM_AR_KE(SQL View) |
Index Back |
|---|---|
Array Key ColumnsGlobal Payroll Array Key Columns Record |
| SELECT PIN_NUM , SEQ_NUM5 , ARRAY_KEY_TYPE , USE_MAX_IND , FIELDNAME , ARRAY_KEY_OPER , ENTRY_TYPE_ID , PIN_ELEM_NUM , EFFDT_COMPARE_OPTN FROM PS_GP_ARRAY_KEY WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , SEQ_NUM5 , ARRAY_KEY_TYPE , USE_MAX_IND , FIELDNAME , ARRAY_KEY_OPER , ENTRY_TYPE_ID , PIN_ELEM_NUM , EFFDT_COMPARE_OPTN FROM PS_GPSC_RM_AR_KEY 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 | ARRAY_KEY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Array Payee/Non Payee Type
D=Effective Date I=Employee ID O=Other Key R=Employee Record |
| 4 | USE_MAX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Obsolete field found on GP ARRAY KEY table. Can be removed.
Y/N Table Edit |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: %GP_EDIT_FLD2 |
| 6 | ARRAY_KEY_OPER | Character(2) | VARCHAR2(2) NOT NULL |
Array Key Operator
EQ=Equal GE=Greater Than or Equal GT=Greater Than LE=Less Than or Equal LT=Less Than NA=Not Applicable NE=Not Equal |
| 7 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: %RECNAME_EDIT2 |
| 8 | PIN_ELEM_NUM | Number(8,0) | INTEGER NOT NULL |
Element Number
Prompt Table: %GP_EDIT_FLD1 |
| 9 | EFFDT_COMPARE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Array Effective Date Compare Option
1=Period Begin Date 2=Period End Date 3=Payment Date 4=Segment Begin Date 5=Segment End Date 6=Slice Begin Date 7=Slice End Date |