TS130_CNTRL_COM(SQL Table) |
Index Back |
---|---|
TS130 Control - CommunicationsDefine PERS records fro TS130. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
4 | COMM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
TS130 Communication Number Qualifier
AP=Alternate Telephone AS=Answering Service BN=Beeper Number CP=Cellular Phone EM=Electronic Mail EX=Telephone Extension FX=Fax HF=Home Fax Number HP=Home Phone Number NP=Night Telephone OF=Other Residential Fax OT=Other Residential Phone PA=Appointment Phone PC=Personal cellular PP=Personal Phone TE=Telephone TL=Telex TM=Telemail TN=Teletex Number VM=Voice Mail WC=Work Cellular WF=Work Fax Number WP=Work Phone Number |
5 | EDI_COMM | Character(80) | VARCHAR2(80) NOT NULL | Communication Number |