MEMBER STATUS (DIM_MEMBER_STATUS) MEMBER STATUS (DIM_MEMBER_STATUS)

This holds details of the applicant/ student's status.  It is based upon the STA Form records in SITS.

Column Name Data Type Description Derivation
member_status_sk integer This uniquely identifies the status record. The value increments each time a record is entered into the table.
member_status_shortname varchar Short description of the status Based upon sta_snam
member_status varchar The description of the status. Based upon sta_name 
member_status_group  varchar  Higher level grouping of statuses.  Main categories are 'APPLICANT', 'CURRENT STUDENT', 'TRANSFERRED', 'WITHDRAWN'  AND 'COURSE COMPLETE' Based largely upon discussions with Adam Green of BIU. 
member_status_code  varchar  SITS Code for status.  Based upon sta_code