SSR_HE_HIN_RC

(SQL Table)
Index Back

Import HIN Target List Run Ctl

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

4 SSR_HE_PRD_CODE Character(10) VARCHAR2(10) NOT NULL Reporting Period

Prompt Table: SSR_HE_REPRD_VW

5 SSR_HE_FILE_PATH Character(100) VARCHAR2(100) NOT NULL XSD File Path
6 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
7 SSR_HE_INCR_YRPRG Character(1) VARCHAR2(1) NOT NULL Increment Year of Program

Y/N Table Edit

Default Value: N

8 SSR_HE_INS_IND Character(1) VARCHAR2(1) NOT NULL Copy Instance Details Indicator

Y/N Table Edit

Default Value: Y

9 SSR_HE_QUALAWD_IND Character(1) VARCHAR2(1) NOT NULL Copy Qualifications Awarded Indicator

Y/N Table Edit

Default Value: Y

10 SSR_HE_RSCH_IND Character(1) VARCHAR2(1) NOT NULL Copy research data flag

Y/N Table Edit

Default Value: Y

11 SSR_HE_FTE_IND Character(1) VARCHAR2(1) NOT NULL Copy FTE Details Indicator

Y/N Table Edit

Default Value: Y

12 SSR_HE_FIN_IND Character(1) VARCHAR2(1) NOT NULL Copy Financial Support Details Indicator

Y/N Table Edit

Default Value: Y

13 SSR_HE_MOB_IND Character(1) VARCHAR2(1) NOT NULL Copy Mobility Details Indicator

Y/N Table Edit

Default Value: Y

14 SSR_HE_ITT_PLC Character(1) VARCHAR2(1) NOT NULL ITT Placement check box

Y/N Table Edit

Default Value: Y