SSR_HE_INST_DAT

(SQL Table)
Index Back

Institution Data Capture

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 SSR_HE_FIELD Character(20) VARCHAR2(20) NOT NULL Field

Prompt Table: SSR_HE_FIELD_VW

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
5 SSR_HE_SEPARATE Character(3) VARCHAR2(3) NOT NULL Display Region
ENP=Entry Profile
FED=Further Education
INS=Instance
KCR=KIS Course
LOC=KIS Location
NTD=Not Displayed
OTH=Other
OVS=Aggregate Offshore
RES=Restricted
6 SSR_HE_INSTTN_FLAG Character(1) VARCHAR2(1) NOT NULL Institution Flag

Y/N Table Edit

Default Value: N

7 SSR_HE_STUDENT_FLG Character(1) VARCHAR2(1) NOT NULL Student

Y/N Table Edit

Default Value: N

8 SSR_HE_INSTANC_FLG Character(1) VARCHAR2(1) NOT NULL Instance

Y/N Table Edit

Default Value: N

9 SSR_HE_ADVISR_FLG Character(1) VARCHAR2(1) NOT NULL Advisor Flag

Y/N Table Edit

Default Value: N

10 SSR_HE_PRGM_FLAG Character(1) VARCHAR2(1) NOT NULL Program

Y/N Table Edit

Default Value: N

11 SSR_HE_PRGM_OFRFLG Character(1) VARCHAR2(1) NOT NULL Program Offering

Y/N Table Edit

Default Value: N

12 SSR_HE_PRGM_OYRFLG Character(1) VARCHAR2(1) NOT NULL Program Offering Year

Y/N Table Edit

Default Value: N

13 SSR_HE_PLAN_FLAG Character(1) VARCHAR2(1) NOT NULL Plan

Y/N Table Edit

Default Value: N

14 SSR_HE_PLN_OFFRFLG Character(1) VARCHAR2(1) NOT NULL Plan Offering

Y/N Table Edit

Default Value: N

15 SSR_HE_PLN_OYR_FLG Character(1) VARCHAR2(1) NOT NULL Plan Offering Year

Y/N Table Edit

Default Value: N

16 SSR_HE_SPLAN_FLAG Character(1) VARCHAR2(1) NOT NULL Subplan

Y/N Table Edit

Default Value: N

17 SSR_HE_SPLN_OFRFLG Character(1) VARCHAR2(1) NOT NULL Sub-Plan Offering

Y/N Table Edit

Default Value: N

18 SSR_HE_SPLN_OYRFLG Character(1) VARCHAR2(1) NOT NULL Sub-Plan Offering Year

Y/N Table Edit

Default Value: N

19 SSR_HE_MODULE_FLG Character(1) VARCHAR2(1) NOT NULL Module

Y/N Table Edit

Default Value: N