| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 2 |
SAD_CA_SRV_IND_RS |
Character(3) |
VARCHAR2(3) NOT NULL |
Service indicator �removed student�.
Prompt Table:
SRVC_IND_CD_TBL
|
| 3 |
SAD_CA_SRV_IND_WR |
Character(4) |
VARCHAR2(4) NOT NULL |
Service indicator WAPP reason
Prompt Table:
SAD_CA_WPRSN_VW
|
| 4 |
SAD_CA_METHOD_AP |
Character(3) |
VARCHAR2(3) NOT NULL |
Application method - application
DSK=Diskette
EDI=EDI
HRD=Hard Copy
OUA=Ontario University Application
SRV=Application Service
WWW=Web Application
|
| 5 |
SAD_CA_METHOD_IN |
Character(3) |
VARCHAR2(3) NOT NULL |
Application method - interest
DSK=Diskette
EDI=EDI
HRD=Hard Copy
OUA=Ontario University Application
SRV=Application Service
WWW=Web Application
|
| 6 |
SAD_CA_CAF_CHAINID |
Character(20) |
VARCHAR2(20) NOT NULL |
Holds name of custom added CAF attribute to store text value of .
Prompt Table:
SAD_CA_APCFT_VW
|
| 7 |
SAD_CA_CAF_SEQ_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Holds name of custom added CAF attribute to store numerical value of
Prompt Table:
SAD_CA_APCFN_VW
|
| 8 |
SAD_CA_PHN_HOME_TP |
Character(4) |
VARCHAR2(4) NOT NULL |
PHONE �HOME� 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
|
| 9 |
SAD_CA_PHN_CELL_TP |
Character(4) |
VARCHAR2(4) NOT NULL |
PHONE �CELL� 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
|
| 10 |
SAD_CA_PRI_NAME_TP |
Character(3) |
VARCHAR2(3) NOT NULL |
Name type to use for insert/update by CA interface
Prompt Table:
NAME_TYPE_TBL
|
| 11 |
SAD_CA_PPL_REL_G1 |
Character(2) |
VARCHAR2(2) NOT NULL |
First legal guardian (CA)
|
| 12 |
SAD_CA_PPL_REL_G2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Second legal guardian (CA)
|
| 13 |
SAD_CA_GRD_REL_XLV |
Character(2) |
VARCHAR2(2) NOT NULL |
Bug 35072228 - Updated label names, added XG
configurable value of (xlat of) GUARDIAN_RELATIONS
LG=Legal Guardian
NA=Not Applicable
OT=Other
PG=Parent Guardian
SG=Self Guardian
XG=Primary guardian
|
| 14 |
SAD_CA_GRD_RL_XLV2 |
Character(2) |
VARCHAR2(2) NOT NULL |
configurable value of (xlat of) GUARDIAN_RELATIONS second relationship
LG=Legal Guardian
NA=Not Applicable
OT=Other
PG=Parent Guardian
SG=Self Guardian
XG=Primary guardian
|
| 15 |
SAD_CA_ADR_HOME_TP |
Character(4) |
VARCHAR2(4) NOT NULL |
Adres type HOME
Prompt Table:
ADDRESS_TYP_TBL
|
| 16 |
SAD_CA_EML_HOME_TP |
Character(4) |
VARCHAR2(4) NOT NULL |
Email type HOME
BUSN=Business
CAMP=Campus
DORM=Dorm
HOME=Home
OTHR=Other
|
| 17 |
SAD_CA_ADMTYPE_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Admit Type
Prompt Table:
SAD_CA_ADMTP_VW
|
| 18 |
SAD_CA_APPLCTR_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Application Center
Prompt Table:
ADM_APPLCTR_TBL
|
| 19 |
SAD_CA_FORM_STUDY |
Character(4) |
VARCHAR2(4) NOT NULL |
CA Form of Study Higher Education
A=Auditor
D=Participant
E=Extraneus
S=Student
T=Coop/Dual
|
| 20 |
SAD_CA_ACAD_LVL |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level
00=Not Set
01=First Year
02=Second Year
03=Thrid Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=Phd
|
| 21 |
SAD_CA_DEF_RSN_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
CA default WAPP reason
Prompt Table:
SAD_CA_WPRSN_VW
|
| 22 |
SAD_CA_CAFEXS_NLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Bug 35072228 - CAF Extra support
Prompt Table:
SAD_CA_APCFB_VW
|