|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_Pos_ALA_APAJobClassCode |
Code (abbreviation) corresponding to MD_Pos_APAJobCLass. |
DW_CodeDescShort |
varchar(16) |
16 |
|
MD_Pos_HEITSSurveyClass |
Position classifications used by HEITS (higher-ed IT), e.g., for their annual salary survey. |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_Pos_HEITSSurveyClassCode |
Code (abbreviation) corresponding to MD_Pos_HEITSSurveyClass. |
DW_CodeDescShort |
varchar(16) |
16 |
|
MD_Pos_CUPAClass |
CUPA-HR is a higher ed HR organization. This (custom Carleton) attribute allows us to categorize positions using CUPA's system. |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_Pos_CUPAClassCode |
Code (abbreviation) corresponding to MD_Pos_CUPAClass. |
DW_CodeDescShort |
varchar(16) |
16 |
|
MD_Pos_DeptOfLaborClass |
|
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_Pos_DeptOfLaborClassCode |
DOL code in Colleague, i.e., the US Department of Labor position type code. |
DW_CodeDescShort |
varchar(16) |
16 |
|
MD_Pos_RowStart |
|
DW_RowStart |
datetime |
|
|
MD_Pos_RowEnd |
|
DW_RowEnd |
datetime |
|
|
MD_Pos_RowIsCurrent |
|
DW_BooleanNoDefault |
bit |
|
|
MD_Pos_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MD_Pos_Type1Checksum |
|
DW_Checksum |
int |
|
|
MD_Pos_Type2Checksum |
|
DW_Checksum |
int |
|
|
MD_Pos_Timestamp |
|
<None> |
timestamp |
|
|
|
|