SSR_HE_REBEX_FL

(SQL Table)
Index Back

HESA ReligiousBExtract Fields

HESA Religious Bg Extract Fields

# 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_RET_NAME Character(30) VARCHAR2(30) NOT NULL Return Name

Prompt Table: SSR_HE_INST_HER

3 SSR_HE_SID Character(20) VARCHAR2(20) NOT NULL Student Identifier
4 SSR_HE_VALID_FROM Date(10) DATE HESA Valid From
5 SSR_HE_FIELD Character(20) VARCHAR2(20) NOT NULL Field
6 SSR_HE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active

Y/N Table Edit

7 SSR_HE_DERIVED_VAL Character(254) VARCHAR2(254) NOT NULL Derived Value
8 SSR_HE_DERIVE_STEP Number(3,0) SMALLINT NOT NULL Derivation Step
9 SSR_HE_REP_VAL Character(254) VARCHAR2(254) NOT NULL Reported Value
10 SSR_HE_OVRDN_FLG Character(1) VARCHAR2(1) NOT NULL Derived Value Overriden

Y/N Table Edit

Default Value: N

11 SSR_HE_FLD_STATUS Character(1) VARCHAR2(1) NOT NULL Field Status
A=Amended
D=Delete
E=Error
N=New
U=Unchanged