SSF_IHC_STDPAR(SQL Table) |
Index Back |
---|---|
Student Data for OSHC - ParentThis 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. |
# | 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 |