SSF_PMT_ADMS_VW

(SQL View)
 Index Back

SELECT B.INSTITUTION_SET , B.BUSINESS_UNIT , A.EMPLID , A.ACAD_CAREER , A.ADM_APPL_NBR , A.APPL_PROG_NBR , A.EFFDT , A.EFFSEQ , A.SF_PMT_REF_NBR FROM PS_SSF_PMT_ADM_PRG A , PS_ISET_BU_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

# 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 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 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
7 EFFDT Date(10) DATE Effective Date

Default Value: %date

8 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
9 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr