SSF_IHC_STDPAR

(SQL Table)
Index Back

Student Data for OSHC - Parent

This record is the parent to the record that stores the student specific data relating to the Overseas Student Health Cover (OSHC). It should be populated only for International students and it will be populated when an applicant is entered into the system.

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HCR_PERSON_I

    2 SSF_IHC_COVER_NBR Number(3,0) SMALLINT NOT NULL Coverage Number
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: SSF_IHC_DEFAULT.BUSINESS_UNIT

    Prompt Table: SSF_IHC_DEFAULT