ADM_WEB_PRS_TBL(SQL Table) |
Index Back |
|---|---|
Web Prospect Setup TableThis table contains the setup values for Web Prospect Create. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADM_INT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Academic Interests
Y/N Table Edit Default Value: N |
| 2 | ADM_TST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Test Results
Y/N Table Edit Default Value: N |
| 3 | ADM_PRG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Create Web Prospect Acadmic Program flag.
Y/N Table Edit Default Value: N |
| 4 | ADM_PLN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Create Web Prospect Academic Plan flag.
Y/N Table Edit Default Value: N |
| 5 | ADM_SPLN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Create Web Prospect Academic Sub-Plan flag.
Y/N Table Edit Default Value: N |
| 6 | ADM_CAMPUS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Web Prospect Create Campus flag.
Y/N Table Edit Default Value: N |
| 7 | ADM_TERM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Admit Term
Y/N Table Edit Default Value: Y |
| 8 | ADM_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Admit Type
Y/N Table Edit Default Value: N |
| 9 | ADM_ACAD_LVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Academic Level
Y/N Table Edit Default Value: N |
| 10 | ADM_ACAD_LD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Academic Load
Y/N Table Edit Default Value: N |
| 11 | HOUSING_INTEREST | Character(1) | VARCHAR2(1) NOT NULL |
Housing Interest
C=Commuter F=Off Campus Housing H=On Campus Housing Y/N Table Edit Default Value: N |
| 12 | FIN_AID_INTEREST | Character(1) | VARCHAR2(1) NOT NULL |
Financial Aid Interest
Y/N Table Edit Default Value: N |
| 13 | ADM_SCHL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Last School Attended
Y/N Table Edit Default Value: N |
| 14 | ADM_GRAD_DT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Graduation Date
Y/N Table Edit Default Value: N |
| 15 | LS_DATA_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Data Source
A8=TEAS Degree Information AAD=AADSAS ACT=American College Testing AE=Ad-Hoc Employee AMC=AMCAS AO=Ad-Hoc Organizational E=Extract ETS=Educational Testing Service GH=OLSAS Last Secondary-G2 LSD=LSDAS PI=Prev/Post Secondary Info RS=OLSAS Postsecondary Info SCH=School SLF=Self-Reported Information WWW=World Wide Web Default Value: WWW |
| 16 | ADM_INST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Web Prospect Create Single Institution flag.
Y/N Table Edit Default Value: N |
| 17 | ADM_ACAD_INF_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Web Prospect Create Academic Information flag.
Y/N Table Edit Default Value: N |