SSF_PADMS_SR_VW

(SQL View)
 Index Back

SF Matriculation View


SELECT C.INSTITUTION_SET , A.BUSINESS_UNIT , A.EMPLID , A.OPRID , A.GRP_TIMESTAMP , A.ACAD_CAREER , A.ADM_APPL_NBR , A.APPL_PROG_NBR , B.STDNT_CAR_NBR_SR , A.EFFDT , A.EFFSEQ , A.RECEIPT_NBR , A.SF_PMT_REF_NBR FROM PS_SSF_PMT_ADM_PRG A , PS_ADM_APP_CAR_SEQ B , PS_ISET_BU_DTL C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND A.EMPLID = B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND B.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND A.ADM_APPL_NBR = B.ADM_APPL_NBR AND A.APPL_PROG_NBR = B.APPL_PROG_NBR AND B.CREATE_PROG_STATUS = 'S'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

Prompt Table: SP_BU_SF_NONVW

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH_SF

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 GRP_TIMESTAMP DateTime(26) TIMESTAMP Group Line Time Stamp
6 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
7 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
8 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
9 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
10 EFFDT Date(10) DATE Effective Date

Default Value: %date

11 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
12 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
13 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr