SEQ_NUM5Prompt Table: ACTION_TBL
Prompt Table: ACTN_REASON_TBL
Prompt Table: GPFR_AF_SIT_FLD
Prompt Table: GPFR_DA_COD7_VW
Prompt Table: GPFR_DA_COD8_VW
A=Active
I=Inactive
Default Value: A
Y/N Table Edit
GPFR_DA_SIT(SQL Table) |
Index Back |
|---|---|
DADS Situation SetupDADS related record: store the situation setup used in the DADS process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEQ_NUM5 |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 2 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 3 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 4 | GPFR_AF_SIT_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Application Framework - Situation Change
Prompt Table: GPFR_AF_SIT_FLD |
| 5 | GPFR_DA_BGN_REASON | Character(3) | VARCHAR2(3) NOT NULL |
DADS related field.
Prompt Table: GPFR_DA_COD7_VW |
| 6 | GPFR_DA_END_REASON | Character(3) | VARCHAR2(3) NOT NULL |
DADS related field.
Prompt Table: GPFR_DA_COD8_VW |
| 7 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 8 | GPFR_AF_SAVED | Character(1) | VARCHAR2(1) NOT NULL |
Field for Saved
Y/N Table Edit |