ADM_PRSPCT_PROG(SQL Table) |
Index Back |
---|---|
Admission Prospect ProgramThis table contains the academic programs that an admission prospect is interested in and/or is being recruited for. Careers that recruit for specific programs or have decentralized recruiting program can use this, but it is not required. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: SCC_PERS_SA_VW.EMPLID Prompt Table: PEOPLE_SRCH |
2 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine Default Value: ADM_PRSPCT_CAR.ACAD_CAREER Prompt Table: STDNT_CAREER |
3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: ADM_PRSPCT_CAR.INSTITUTION Prompt Table: INST_CAR_SCTY |
4 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL |
Academic Program
Default Value: OPR_DEF_TBL_CS.ACAD_PROG Prompt Table: SAD_PRS_PRG_VW |
5 | ADM_RECR_CTR | Character(4) | VARCHAR2(4) NOT NULL |
Recruiting Center
Default Value: ADM_PRSPCT_CAR.ADM_RECR_CTR Prompt Table: ADM_RECRCTR_SVW |
6 | RECRUITING_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Recruiting Status
APPL=Applicant INAC=Inactive INQR=Inquiry PAPL=Pre-Applicant PROS=Prospect SUSP=Suspect Default Value: ADM_PRSPCT_CAR.RECRUITING_STATUS |
7 | RECR_STATUS_DT | Date(10) | DATE |
Recruiting Status Date
Default Value: %date |
8 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL |
Campus
Default Value: ADM_PRSPCT_CAR.CAMPUS Prompt Table: HOME_CAMPUS_VW |
9 | ADM_APPL_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Application Nbr
Prompt Table: ADM_APPL_DATA |