GP_AUD_ARKE_VW(SQL View) |
Index Back |
|---|---|
Array Key ColumnsGlobal Payroll Array Key Columns Record |
| SELECT A.PIN_NUM ,A.SEQ_NUM5 ,A.ARRAY_KEY_TYPE ,A.USE_MAX_IND ,A.FIELDNAME ,A.ARRAY_KEY_OPER ,A.ENTRY_TYPE_ID ,A.PIN_ELEM_NUM ,'' ,'' ,'' ,A.EFFDT_COMPARE_OPTN FROM PS_GP_ARRAY_KEY A |
| # | 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 | GP_AUD_CHAR_NM2 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 10 | GP_AUD_LINK2 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 11 | GP_AUD_CHAR_VAL2 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 12 | 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 |