| # |
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
Default Value: 1
|
| 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
Default Value: O
|
| 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
Default Value: N
|
| 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
Default Value: NA
|
| 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
Default Value: 2
|