GPFR_DA_STRUCTPIN_NUMPrompt Table: %GP_EDIT_FLD1
Prompt Table: GPFR_DA_RECORD
Prompt Table: GPFR_DA_PINVW
A=Add
S=Subtract
Default Value: A
GPFR_DA_PIN(SQL Table) |
Index Back |
|---|---|
Elements Attached to a RecordDADS related record: to store the elements attached to a record used in the DADS process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DA_STRUCT |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 2 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD1 |
| 3 | GPFR_DA_RECORD | Character(10) | VARCHAR2(10) NOT NULL |
DADS related record
Prompt Table: GPFR_DA_RECORD |
| 4 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GPFR_DA_PINVW |
| 5 | GPFR_DA_SIGN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Sign Indicator
A=Add S=Subtract Default Value: A |