E_ADDR_TYPEBUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
Prompt Table: EMAIL_TYPE_VW
D=Display Only
F=Full Edit
N=Do Not Display
U=Edit - No Delete
Default Value: N
Default Value: N
TYPE_CNTL_EMAIL(SQL Table) |
Index Back |
|---|---|
Email type control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | E_ADDR_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Email Type
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other Prompt Table: EMAIL_TYPE_VW |
| 2 | TYPE_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Type Control
D=Display Only F=Full Edit N=Do Not Display U=Edit - No Delete Default Value: N |
| 3 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N |