GPFR_DA_ESTREPPrompt Table: NAME_PREFIX_TBL
Prompt Table: ESTAB_TBL
Prompt Table: GPFR_DA_COD6_VW
GPFR_DA_ESTREP(SQL Table) |
Index Back |
|---|---|
DADS Reporting EstablishmentDADS related record: store the reporting establishments for DADS. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DA_ESTREP |
Character(12) | VARCHAR2(12) NOT NULL | DADS related field. |
| 2 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 3 | GPFR_DA_CONNM | Character(50) | VARCHAR2(50) NOT NULL | DADS related field |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | GPFR_DA_REPESTAB | Character(12) | VARCHAR2(12) NOT NULL |
DADS related field
Prompt Table: ESTAB_TBL |
| 6 | GPFR_DA_COMMOD | Character(10) | VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table: GPFR_DA_COD6_VW |
| 7 | GPFR_DA_COMDET | Character(50) | VARCHAR2(50) NOT NULL | DADS related field |