GPFR_DA_SNDREFGPFR_DA_COMPANYPrompt Table: COMPANY_TBL
GPFR_DA_ESTABPrompt Table: ESTAB_COMP_VW
GPFR_DSN_DSNTYPEPrompt Table: GPFR_DSN_NODSET
GPFR_DA_CONNMGPFR_DA_CON_TYPEPrompt Table: GPFR_CONTYP_VW
GPFR_DSN_CNTCT2(SQL Table) |
Index Back |
|---|---|
DSN:Contacts details estabDSN:Contacts details at establishment level. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DA_SNDREF |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 2 | GPFR_DA_COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
DADS related field
Prompt Table: COMPANY_TBL |
| 3 | GPFR_DA_ESTAB |
Character(12) | VARCHAR2(12) NOT NULL |
DADS related field
Prompt Table: ESTAB_COMP_VW |
| 4 | GPFR_DSN_DSNTYPE |
Character(16) | VARCHAR2(16) NOT NULL |
DSN: DSN Type or Node Set
Prompt Table: GPFR_DSN_NODSET |
| 5 | GPFR_DA_CONNM |
Character(50) | VARCHAR2(50) NOT NULL | DADS related field |
| 6 | GPFR_DA_CON_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Contact Type
Prompt Table: GPFR_CONTYP_VW |
| 7 | GPFR_DA_PHONE | Character(20) | VARCHAR2(20) NOT NULL | GPFR DADS Phone contact |
| 8 | GPFR_CONT_EMAIL | Character(252) | VARCHAR2(252) NOT NULL | Email Address |