Position Count is a unique count on position number. Position numbers are assigned for each position description.
Metadata |
---|
Where Term Appears |
---|
CSUMB Data Warehouse Dashboards: | N/A - Inactive and not available on dashboards |
---|
|
Data Custodian |
---|
University Personnel |
Data Source |
---|
Source System: | CMS - HR |
---|
Source Table Name: | PS_POSITION_DATA |
---|
Source Field Name: | POSITION_NBR |
---|
Census Process: | No |
---|
|
Logical Transformation / Calculation |
---|
Count distinct |
OBIEE Folder and Column |
---|
Folder Heading: | "CSU Employee Metrics" |
---|
Column Heading: | "Position Count" |
---|
|
|
Position count differs from record count (which counts every row in the table) and headcount (which counts every person uniquely).
Multiple people may hold the same position, so the Position Count is often less than the record count and headcount. In addition, a single person may have multiple positions (for example, in different departments), so the record count and the position count are often greater than the headcount.