GPFR_DA_ESTREPGPFR_DA_CONNUMA=Active
I=Inactive
Default Value: A
Prompt Table: GPFR_DA_COD5_VW
Prompt Table: NAME_PREFIX_TBL
GPFR_DA_CONREP(SQL Table) |
Index Back |
|---|---|
Contacts for DADS Report EstabDADS related record: store the contacts for reporting establishments for DADS. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DA_ESTREP |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field. |
| 2 | GPFR_DA_CONNUM |
Number(5,0) | INTEGER NOT NULL | DADS related field |
| 3 | GPFR_DA_CONNM | Character(50) | VARCHAR2(50) NOT NULL | DADS related field |
| 4 | GPFR_DA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
A=Active I=Inactive Default Value: A |
| 5 | GPFR_DA_INTDOM | Character(10) | VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table: GPFR_DA_COD5_VW |
| 6 | GPFR_DA_CONDET | Character(50) | VARCHAR2(50) NOT NULL | DADS related field |
| 7 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 8 | GPFR_DA_PHONE | Character(20) | VARCHAR2(20) NOT NULL | GPFR DADS Phone contact |
| 9 | GPFR_DA_FAX | Character(20) | VARCHAR2(20) NOT NULL | GPFR DADS Contact Fax. |