| Data element |
Definition |
| Billing_Credits_Bu Indexed - no
Format - Number (22)
May be Null? Y | This field stores the number of billing hours associated with this student for this section. Source field: SFRSTCA_BILL_HR. |
| Course_Id Indexed - no
Format - Varchar2 (36)
May be Null? Y | The subject and course number presented together in one field. No extra spaces are added in-between subject and course number. |
| Course_Number Indexed - no
Format - Varchar2 (20)
May be Null? Y | Number (stored as char) associated with the Subject, that identifies the course. Source field: SSBSECT_CRSE_NUMB for current enrollments, SHRTCKN_CRSE_NUMB for academic history. |
| Crn Indexed - yes
Format - Varchar2 (20)
May be Null? Y | The Course Registration Number of the section the student is registered in. Source field: SFRSTCA_CRN. |
| Grade_Mode Indexed - no
Format - Varchar2 (4)
May be Null? Y | This is the grading mode for this student for this section. Source field: SFRSTCA_GMOD_CODE. |
| Penn_Id Indexed - yes
Format - Varchar2 (36)
May be Null? Y | Penn identity management system''s identification number. Source: SPRIDEN_ID |
| Pidm Indexed - yes
Format - Number (22)
May be Null? Y | The student''s internal identification number. Source field: SFRSTCA_PIDM. |
| Refresh_Date Indexed - no
Format - Date (7)
May be Null? Y | Last date that this record in the warehouse was refreshed. |
| Reg_Activity_Date Indexed - no
Format - Date (7)
May be Null? Y | The date this record was last added or changed. Source field: SFRSTCA_ACTIVITY_DATE. |
| Reg_Add_Date Indexed - no
Format - Date (7)
May be Null? Y | The date this student was first added to this section. Source field: SFRSTCA_ADD_DATE. |
| Reg_Attempt_Hr Indexed - no
Format - Number (22)
May be Null? Y | REGISTRATION ATTEMPTED HOURS: This field stores the number of attempted hours for this student for this section. Source field: SFRSTCA_ATTEMPT_HR. |
| Reg_Blck_Code Indexed - no
Format - Varchar2 (40)
May be Null? Y | BLOCK: Block code student is registered. Source field: SFRSTCA_BLCK_CODE. |
| Reg_Brdh_Seq_Num Indexed - no
Format - Number (22)
May be Null? Y | BLOCK RULE SEQUENCE NUMBER: Sequence number that uniquely identifies the rule for block assignment. Source field: SFRSTCA_BRDH_SEQ_NUM. |
| Reg_Campus_Code Indexed - no
Format - Varchar2 (12)
May be Null? Y | The campus code for this section. Source field: SFRSTCA_CAMP_CODE. |
| Reg_Credit_Bu Indexed - no
Format - Number (22)
May be Null? Y | This field stores the number of credit hours associated with this student for this section. Source field: SFRSTCA_CREDIT_HR. |
| Reg_Current_Time Indexed - no
Format - Timestamp(9) (11)
May be Null? Y | CURRENT TIME: The current time of the registration. Source field: SFRSTCA_CURRENT_TIME. |
| Reg_Data_Orgin Indexed - no
Format - Varchar2 (120)
May be Null? Y | DATA SOURCE: Source system that created or updated the row Source field: SFRSTCA_DATA_ORIGIN. |
| Reg_Enrl Indexed - no
Format - Number (22)
May be Null? Y | ENROLLMENT: The SSBSECT_ENRL value at the time of the registraiton. Source field: SFRSTCA_ENRL. |
| Reg_Error_Flag Indexed - no
Format - Varchar2 (4)
May be Null? Y | This flag identifies an error associated with the registration of this student in this section. Source field: SFRSTCA_ERROR_FLAG. |
| Reg_Gcmt_Code Indexed - no
Format - Varchar2 (28)
May be Null? Y | Source field: SFRSTCA_GCMT_CODE. |
| Reg_Level_Code Indexed - no
Format - Varchar2 (8)
May be Null? Y | The level of the student as registered in this section. Source field: SFRSTCA_LEVL_CODE. |
| Reg_Message Indexed - no
Format - Varchar2 (800)
May be Null? Y | This field stores a message associated with the registration of this student in this section. Source field: SFRSTCA_MESSAGE. |
| Reg_Rmsg_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | MESSAGE CODE: Specifies the type of error message. Source field: SFRSTCA_RMSG_CDE. |
| Reg_Rmsg_Local_Message Indexed - no
Format - Varchar2 (200)
May be Null? Y | MESSAGE TEXT: The message text as delivered. Source - SFRRMSG_MESSAGE |
| Reg_Rmsg_Text Indexed - no
Format - Varchar2 (200)
May be Null? Y | LOCALLY DEFINED MESSAGE: Client defined message text, overrides the delivered text. Source - SFRRMSG_LOCAL_MESSAGE. |
| Reg_Seats_Avail Indexed - no
Format - Number (22)
May be Null? Y | SEATS AVAILABLE: The SSBSECT_SEATS_AVAIL value at the time of the registration. Source field: SFRSTCA_SEATS_AVAIL. |
| Reg_Seq_Num Indexed - yes
Format - Number (22)
May be Null? Y | The sequence number of this record for this student for this registration term. Source field: SFRSTCA_SEQ_NUMBER. |
| Reg_Sesisonid Indexed - no
Format - Varchar2 (120)
May be Null? Y | SESSIONID: The session id value for the registration. Source field: SFRSTCA_SESSIONID. |
| Reg_Source_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | SOURCE CODE. This field shows the source of the audit record. TEMP = SFTREGS (Registration Temp Table), BASE = SFRSTCR (Registation Table). BASE indicates that the record was on the student''s registration record at on point. The TEMP indicates that the record only made it to the temp table. This could be due to a number of reasons such as a registration violation that did not allow the record to be moved on to the registration table for the student. Source field: SFRSTCA_SOURCE_CDE. |
| Reg_Status Indexed - no
Format - Varchar2 (8)
May be Null? Y | The course registration status for this student for this section. Source field: SFRSTCA_RSTS_CODE. |
| Reg_Status_Date Indexed - no
Format - Date (7)
May be Null? Y | The date the course registration status was entered or last updated. Source field: SFRSTCA_RSTS_DATE. |
| Reg_Strd_Seqno Indexed - no
Format - Number (22)
May be Null? Y | STRUCTURED REGISTRATION SEQUENCE NUMBER: The Unique Id within the Structured Registration Program and Requirement for the requirement detail. Source field: SFRSTCA_STRD_SEQNO. |
| Reg_Strh_Seqno Indexed - no
Format - Number (22)
May be Null? Y | STRUCTURED REGISTRATION HEADER SEQUENCE NUMBER: The Unique Id of the Structured Registration Header Record which contains the type of requirement and program. Source field: SFRSTCA_STRH_SEQNO. |
| Reg_Stsp_Key_Sequence Indexed - no
Format - Number (22)
May be Null? Y | STUDY PATH SEQUENCE: Key sequence of the study path under which the CRN is registered. Source field: SFRSTCA_STSP_KEY_SEQUENCE. |
| Reg_Surrogate_Id Indexed - no
Format - Number (22)
May be Null? Y | SURROGATE ID: Immutable unique key Source field: SFRSTCA_SURROGATE_ID. |
| Reg_User Indexed - no
Format - Varchar2 (120)
May be Null? Y | This is the userid of the individual who caused this recorded to be created. Source field: SFRSTCA_USER. |
| Reg_User_Id Indexed - no
Format - Varchar2 (120)
May be Null? Y | USER ID: The user ID of the person who inserted or last updated this record. Source field: SFRSTCA_USER_ID. |
| Reg_Version Indexed - no
Format - Number (22)
May be Null? Y | VERSION: Optimistic lock token. Source field: SFRSTCA_VERSION. |
| Reg_Vpdi_Code Indexed - no
Format - Varchar2 (24)
May be Null? Y | VPDI CODE: Multi-entity processing code. Source field: SFRSTCA_VPDI_CODE. |
| Section_Id Indexed - no
Format - Varchar2 (48)
May be Null? Y | The subject, course number, and section number presented together in one field. No extra spaces are added in-between subject, course number, and section number. |
| Section_Number Indexed - no
Format - Varchar2 (12)
May be Null? Y | The number (stored as char) for the specific Section. Source field: SSBSECT_SEQ_NUMB for current enrollments, SHRTCKN_SEQ_NUMB for academic history. |
| St_Reg_Audit_Pk Indexed - yes
Format - Varchar2 (140)
May be Null? Y | Internal warehouse primary key: based on PIDM and PRIORITY. |
| Subject_Area Indexed - no
Format - Varchar2 (16)
May be Null? Y | Code for the subject area of the course section. Source validation table: STVSUBJ. Warehouse validation table: V_SUBJECT. |
| Term Indexed - yes
Format - Varchar2 (24)
May be Null? Y | This field indentifies the registration term code. Source field: SFRSTCA_TERM_CODE. |
