INSTALLATION_AD(SQL Table) |
Index Back |
|---|---|
AD Installation TableInstallation Table for Admissions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LAST_SCH_ATTD_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Warning for Last School Attend
Y/N Table Edit Default Value: N |
| 2 | USE_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Check box to identify the use of Priority field.
Y/N Table Edit Default Value: N |
| 3 | FREE_FORM_INSTN | Character(1) | VARCHAR2(1) NOT NULL |
This field is used on Installation_AD to indicate whether or not the user wants the free form of entry for external organizations (institutions) that the student decided to attend.
Y/N Table Edit Default Value: Y |
| 4 | ADM_REFRL_SRCE | Character(4) | VARCHAR2(4) NOT NULL | Referral Source |
| 5 | APPL_TO_PRSPCT | Character(1) | VARCHAR2(1) NOT NULL |
Copy Appl Data to Prospect
Y/N Table Edit Default Value: N |
| 6 | CREATE_APPL | Character(1) | VARCHAR2(1) NOT NULL |
Create Application
A=Inst, Career, Prog, Admit Term C=Institution, Career P=Institution, Career, Program Default Value: P |
| 7 | CREATE_PRSPCT | Character(1) | VARCHAR2(1) NOT NULL |
Create Prospect if no Match
Y/N Table Edit Default Value: N |
| 8 | DATA_CHOICE | Character(3) | VARCHAR2(3) NOT NULL |
Matching Cateria
C1=Career, Institution C2=Career, Institution, Term C3=Career, Institution, Adm Type C4=Career, Institution, Program C5=Career, Inst, Term, Adm Type C6=Career, Inst, Term, Prog C7=Car, Inst, Term, Ad Type, Prog Default Value: C1 |
| 9 | FIN_HOU_ADMIT | Character(1) | VARCHAR2(1) NOT NULL |
Financial/Housing/Admit Ty
Y/N Table Edit Default Value: N |
| 10 | PRSPCT_APPL_MATCH | Character(1) | VARCHAR2(1) NOT NULL |
Copy Prospect Data To Appl
Y/N Table Edit Default Value: N |
| 11 | RECRUITING_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Recruiting Status
APPL=Applicant INAC=Inactive INQR=Inquiry PROS=Prospect SUSP=Suspect |
| 12 | RECRUIT_CAT | Character(1) | VARCHAR2(1) NOT NULL |
Recruiting Categories
Y/N Table Edit Default Value: N |
| 13 | SCHOOL_GRAD | Character(1) | VARCHAR2(1) NOT NULL |
Last School/Graduation Date
Y/N Table Edit Default Value: N |
| 14 | SSF_IHC_PB | Character(1) | VARCHAR2(1) NOT NULL |
Filed used as push button and/or hyper link to navigate to the IHC Student Maintenance page in page ADM_APPL_DATA. Used as a check box on page INSTALLATION_AD.
Y/N Table Edit Default Value: N |
| 15 | SAD_DUP_CRS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Course Warning
Y/N Table Edit Default Value: Y |