SCC_STGAPPLSECV

(SQL View)
 Index Back

Constituent Staging Appl View

Constituent Staging Appplication Security Search View

SELECT DISTINCT E.OPRID ,F.SCC_TEMP_ID , F.SCC_TRANSAC_CD , %DatePart(A.CREATED_DTTM ) , A.SCC_STG_STATUS , C.LAST_NAME_SRCH , C.FIRST_NAME_SRCH , C.FIRST_NAME , C.LAST_NAME , C.NAME , A.EMPLID , A.USERID , D.INSTITUTION , D.ACAD_CAREER , D.ADM_APPL_NBR , D.SCC_TRANS_STS , D.SCC_TRANS_STS_DT , D.APPL_FEE_STATUS FROM PS_SAD_APL_DAT_STG D , PS_SCRTY_APPL_CTR E , PS_SCC_STG_CONSTIT A , PS_SCC_SL_TRNMAP F , PS_SCC_TRN_SCTY_VW S , PS_SCC_STG_NAMES C WHERE E.INSTITUTION = D.INSTITUTION AND E.ACCESS_CD = 'Y' AND ( E.ADM_APPL_CTR = D.ADM_APPL_CTR OR E.ADM_APPL_CTR = 'ALL' ) AND A.SCC_TEMP_ID = D.SCC_TEMP_ID AND F.SCC_TEMP_ID = A.SCC_TEMP_ID AND F.SCC_TRANSAC_CD = A.SCC_TRANSAC_CD AND S.SCC_TRANSAC_CD = F.SCC_TRANSAC_CD AND S.OPRID = E.OPRID AND C.SCC_TEMP_ID = F.SCC_TEMP_ID AND C.NAME_TYPE = 'PRI'

# 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 Temporary ID

Prompt Table: SCC_STGAPPLSECV

3 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

Prompt Table: SCC_TRN_SCTY_VW

4 SCC_STG_CRETEDDT Date(10) DATE Created Date
5 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
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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
10 NAME Character(50) VARCHAR2(50) NOT NULL Name
11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: SCC_STGE_VW

12 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: SCC_STGU_VW

13 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

14 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
15 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
16 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
17 SCC_TRANS_STS_DT Date(10) DATE Transaction Status Date
18 APPL_FEE_STATUS Character(3) VARCHAR2(3) NOT NULL Application Fee Status
DEF=Deferred Payment
PEN=Pending
REC=Received
WRQ=Waiver Request
WVD=Waived