SSR_HE_PLOYF_VW

(SQL View)
 Index Back

HESA Plan Offering Year Fields

Lists HESA Plan Offering Year Fields View

SELECT INSTITUTION ,ACAD_PLAN ,EFFDT ,ACAD_LOAD_APPR ,SSR_HE_YEARPRG ,SSR_HE_OFSTRM ,SSR_HE_OFSTSESN ,CAMPUS ,SSR_HE_YRTERM ,SSR_HE_YRSESSN ,SSR_HE_FIELD ,SSR_HE_CODE ,CASE WHEN SSR_HE_OFSTSESN = ' ' THEN 'Y' ELSE 'N' END ,CASE WHEN CAMPUS = ' ' THEN 'Y' ELSE 'N' END ,CASE WHEN SSR_HE_OFSTRM = ' ' THEN 'Y' ELSE 'N' END ,CASE WHEN SSR_HE_YRTERM = ' ' THEN 'Y' ELSE 'N' END ,CASE WHEN SSR_HE_YRSESSN = ' ' THEN 'Y' ELSE 'N' END FROM PS_SSR_HE_PLNOYRFL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
5 SSR_HE_YEARPRG Number(2,0) SMALLINT NOT NULL Year of Program
6 SSR_HE_OFSTRM Character(4) VARCHAR2(4) NOT NULL Offering Start Term
7 SSR_HE_OFSTSESN Character(3) VARCHAR2(3) NOT NULL Offering Start Session
8 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
9 SSR_HE_YRTERM Character(4) VARCHAR2(4) NOT NULL Year Term
10 SSR_HE_YRSESSN Character(4) VARCHAR2(4) NOT NULL Year Session
11 SSR_HE_FIELD Character(20) VARCHAR2(20) NOT NULL Field

Prompt Table: SSR_HE_PLNYFLVW

12 SSR_HE_CODE Character(30) VARCHAR2(30) NOT NULL Code

Prompt Table: SSR_HE_CODEVW

13 SSR_HE_SESS_NULL Character(1) VARCHAR2(1) NOT NULL Session Null
14 SSR_HE_CAMP_NULL Character(1) VARCHAR2(1) NOT NULL Campus Null
15 SSR_HE_TERM_NULL Character(1) VARCHAR2(1) NOT NULL Term Null
16 SSR_HE_YRTERM_NULL Character(1) VARCHAR2(1) NOT NULL Year Term Null
17 SSR_HE_YRSESS_NULL Character(1) VARCHAR2(1) NOT NULL Year Session Null