SAD_APPLSTG_SRC(SQL View) |
Index Back |
---|---|
Staging Search Record |
SELECT C.OPRID , A.SCC_TEMP_ID , A.INSTITUTION , A.ACAD_CAREER , A.ADM_APPL_NBR , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , A.SCC_TRANS_STS , A.SCC_TRANS_STS_DT , A.APPL_FEE_STATUS , D.SCC_STG_STATUS FROM PS_SAD_APL_DAT_STG A , PS_SCC_STG_NAMES B , PS_SCRTY_APPL_CTR C , PS_SCC_STG_CONSTIT D WHERE B.NAME_TYPE = 'PRI' AND C.INSTITUTION = A.INSTITUTION AND (C.ADM_APPL_CTR = A.ADM_APPL_CTR OR C.ADM_APPL_CTR = 'ALL') AND c.access_cd = 'Y' AND A.SCC_TEMP_ID = B.SCC_TEMP_ID AND D.SCC_TEMP_ID = A.SCC_TEMP_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | SCC_TEMP_ID | Number(16,0) | DECIMAL(16) NOT NULL |
Temp Constituent ID
Prompt Table: SCC_STG_CONSTIT |
3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
4 | 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 |
5 | ADM_APPL_NBR | Character(8) | VARCHAR2(8) NOT NULL | Application Nbr |
6 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
7 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
8 | SCC_TRANS_STS | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Status
BE=Submitted Error PE=Pending PO=Posted SB=Submitted SE=Saved Error SV=Saved |
9 | SCC_TRANS_STS_DT | Date(10) | DATE | Transaction Status Date |
10 | APPL_FEE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Application Fee Status
DEF=Deferred Payment PEN=Pending REC=Received WRQ=Waiver Request WVD=Waived |
11 | SCC_STG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Constituent Status
AN=Add New ID CN=Cancelled LD=Loaded SA=New ID Created SI=Ignore SS=Suspended SU=ID Updated UE=Update ID VE=Error |