PIN_NUMEFFDTPIN_ELEM_NUMPrompt Table: %RECNAME_EDIT
Prompt Table: %GP_EDIT_FLD1
E=By Eligibility Group
P=By Payee
Default Value: E
GP_ELEM_GRP_MBR(SQL Table) |
Index Back |
|---|---|
Element Group MembersElement Group Members |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | PIN_ELEM_NUM |
Number(8,0) | INTEGER NOT NULL |
Element Number
Prompt Table: %RECNAME_EDIT |
| 4 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: %GP_EDIT_FLD1 |
| 5 | ELEM_ASSIGNMENT | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether an element assignment is done on a payee-by-payee basis or by the eligibility group the payee is associated with.
E=By Eligibility Group P=By Payee Default Value: E |
| 6 | GP_ORDER | Number(3,0) | SMALLINT NOT NULL | Utility field for data ordering |