Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| emplid | varchar | 11 | √ | null |
|
|
||
| ext_org_id | varchar | 11 | √ | null |
|
|
||
| ext_course_nbr | float8 | 17,17 | √ | null |
|
|
||
| ext_crse_type | varchar | 3 | √ | null |
|
|
||
| ls_data_source | varchar | 3 | √ | null |
|
|
||
| ext_data_nbr | float8 | 17,17 | √ | null |
|
|
||
| begin_dt | timestamp | 22 | √ | null |
|
|
||
| end_dt | timestamp | 22 | √ | null |
|
|
||
| ext_term_type | varchar | 4 | √ | null |
|
|
||
| unt_taken | numeric | 5,2 | √ | null |
|
|
||
| grading_scheme | varchar | 3 | √ | null |
|
|
||
| grading_basis | varchar | 3 | √ | null |
|
|
||
| course_level | varchar | 2 | √ | null |
|
|
||
| crse_grade_input | varchar | 3 | √ | null |
|
|
||
| crse_grade_off | varchar | 3 | √ | null |
|
|
||
| school_subject | varchar | 8 | √ | null |
|
|
||
| school_crse_nbr | varchar | 10 | √ | null |
|
|
||
| ext_subject_area | varchar | 4 | √ | null |
|
|
||
| ext_career | varchar | 4 | √ | null |
|
|
||
| ext_term | varchar | 4 | √ | null |
|
|
||
| term_year | float8 | 17,17 | √ | null |
|
|
||
| descr | varchar | 30 | √ | null |
|
|
||
| unt_type | varchar | 3 | √ | null |
|
|
||
| institution | varchar | 5 | √ | null |
|
|
||
| ext_acad_level | varchar | 4 | √ | null |
|
|
||
| trans_credit_flag | varchar | 1 | √ | null |
|
|
||
| can_trns_type | varchar | 2 | √ | null |
|
|
||
| lastupddttm | timestamp | 29,6 | √ | null |
|
|
||
| lastupdoprid | varchar | 30 | √ | null |
|
|
Table contained 0 rows