GPFR_DA_STRUCTPIN_NUMGPFR_DA_RECORDA=Add
S=Subtract
GPFR_DADS_NRVW(SQL View) |
Index Back |
|---|---|
Non-Rule Packager AccessDADS related view: provide an access for the non-rule packager to the elements used in the DADS process. |
| SELECT GPFR_DA_STRUCT , PIN_NUM + 50000000 , GPFR_DA_RECORD , ENTRY_TYPE_ID , GPFR_DA_SIGN_IND FROM PS_GPFR_DA_PIN |
| # | 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 |
| 3 | GPFR_DA_RECORD |
Character(10) | VARCHAR2(10) NOT NULL | DADS related record |
| 4 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Element Entry Type ID |
| 5 | GPFR_DA_SIGN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Sign Indicator
A=Add S=Subtract |