TYPE_CNTL_PHONE(SQL Table) |
Index Back |
---|---|
Phone type control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work Prompt Table: PHONE_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 |