This page (revision-31) was last changed on 26-Nov-2021 10:22 by lurtan

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
31 26-Nov-2021 10:22 8 KB lurtan to previous
30 26-Nov-2021 10:22 8 KB rforbes to previous | to last
29 26-Nov-2021 10:22 8 KB klawler to previous | to last
28 26-Nov-2021 10:22 8 KB jmyers to previous | to last WORK_RULE_CODE ==> WORK_RULE (Field)
27 26-Nov-2021 10:22 8 KB jmyers to previous | to last
26 26-Nov-2021 10:22 8 KB jmyers to previous | to last
25 26-Nov-2021 10:22 8 KB jmyers to previous | to last
24 26-Nov-2021 10:22 8 KB JMyers to previous | to last
23 26-Nov-2021 10:22 8 KB JMyers to previous | to last
22 26-Nov-2021 10:22 8 KB JMyers to previous | to last
21 26-Nov-2021 10:22 22 KB JMyers to previous | to last

Page References

Incoming links Outgoing links
IVDPS
IVDPS

Version management

Difference between version and

At line 1 changed 2 lines
[{TableOfContents }]
!!!Position INTERFACE FILE
The INF_CV_POSITIONS table is used to import position codes and their attendant data into the software data structures. Positions identify the need for a specific job to be done in a particular place in the organization.
At line 4 changed one line
The Position Interface File screen is used to import position codes into the software data structures.
Tables loaded:
*[P2K_CM_POSITIONS] (first record for each position code only)
*[P2K_CM_POSITION_DETAILS] (first record and subsequent effective splits)
*[P2K_SA_PREMIUM_USAGES] (one record for each premium code defined)
*[P2K_CM_DISTRIBUTIONS] (one record for each distribution split defined)
!!Table Columns
\\
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[ENTITY_CODE]|Varchar2(16)|Y|Validation: Must be a valid entity code defined on [P2K_CM_ENTITIES]
|[POSITION_CODE]|Varchar2(16)|Y|Validation: Must be a unique position code for the entity specified
|[STANDING]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_STANDING]. Suggestion: Normally, you would only load active positions, so you could populate this field with a constant value of “A”.
|[GENERIC_CODE]|Varchar2(4)| |
|[POSITION_CODE_GROUPING]|Varchar2(16)| |
|[EFFECTIVE]|Date()|Y|Validation: Must be a valid date format. Suggestion: If you are not loading multiple date-effective records for the same position code, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time.
|[EXPIRY]|Date()| |Validation: Must be a valid date format, with a date after the effective date. Suggestion: If you are not loading multiple date-effective records for the same position code, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time.
|[CHANGE_CODE]|Varchar2(16)| |Validation: The Change Code provided must be defined on [P2K_CM_CHANGE_REASONS]
|[UNIT_CODE]|Varchar2(16)| |Validation: Must be a valid entity code defined on [P2K_CM_UNITS].
|[DEPARTMENT_CODE]|Varchar2(16)| |Validation: Must be a valid position code defined on [P2K_CM_DEPARTMENTS].
|[LOCATION_CODE]|Varchar2(16)| |Validation: Must be a valid LOCATION_CODE defined on [P2K_CM_LOCATIONS]. Derivation: This field is derived from the [LOCATION_CODE] on the [P2K_CM_DEPARTMENT_DETAILS] table for the [DEPARTMENT_CODE] specified.
|[GROUP_CODE]|Varchar2(16)| |Validation: Must be a valid [GROUP_CODE] defined on [P2K_CM_GROUPS]
|[JOB_CODE]|Varchar2(16)| |Validation: Must be a valid [JOB_CODE] defined on [P2K_CM_JOBS]
|[PERSON_CODE]|Varchar2(16)| |Validation: The [PERSON_CODE] must be for a valid employee currently entered on [P2K_HR_IDENTITIES].
|[RANGE_CODE]|Varchar2(16)| |Validation: Must be a valid range code defined on [P2K_SA_SALARY_RANGES]. Derivation: If not specified, this field will be derived from [RANGE_CODE] as specified on the [P2K_CM_JOB_DETAILS] record for the related job
|[WORK_RULE_CODE]|Varchar2(16)| |Validation: Must be a Work Rule Code defined on [P2K_CM_WORK_RULES]. Derivation: If not provided, [WORK_RULE_CODE] will be derived from the value found on the indicated group record [P2K_CM_GROUP_DETAILS].
|[POSITION_CODE_REPORTING_TO]|Varchar2(16)| |Validation: Must be a valid position code already defined on [P2K_CM_POSITIONS]. Derivation: This field will be derived from the Position Code (DPS_ID) found on the [P2K_CM_DEPARTMENT_DETAILS] table, reflecting the manager of the department that is indicated on this position.
|[AUTHORIZATION_CODE]|Varchar2(16)| |Validation: Must be a valid Authorization Code defined on [P2K_CM_AUTHORIZATION_AREAS]. Derivation: If not specified, this field is derived from the [AUTHORIZATION_AREAS] specified on [P2K_CM_DEPARTMENT_DETAILS] for the [DEPARTMENT_CODE] specified.
|[SCALE_CODE]|Varchar2(16)| |Validation: Must be a valid scale code defined on [P2K_SA_WAGE_SCALES]
|[STEP_CODE]|Varchar2(16)| |Validation: Must be a valid step for the scale code defined on [P2K_SA_WAGE_SCALES]. Derivation: If not specified, this field will be derived from the [STEP_CODE] specified on the [P2K_CM_JOB_DETAILS] record referenced by the [JOB_CODE]
|[POSITION_TITLE]|Varchar2(50)| |Derivation: If not specified, this field will be derived from the [JOB_TITLE] for the specified JOB.
|[DESCRIPTION_1]|Varchar2(50)| |
|[DESCRIPTION_2]|Varchar2(50)| |
|[POSITION_TYPE]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_POSITION_TYPE]
|[WCB_CLASS]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_WCB_CLASS]. Derivation: If not provided, [WCB_CLASS] will be derived from the value found on the indicated [SCALE_CODE] / [STEP_CODE].
|[LANGUAGE_CLASS]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_LANGUAGE_CLASS]
|[ORG_CHART_LEVEL]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_ORG_CHART_LEVEL]
|[RESPONSIBILITY_LEVEL]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_RESPONSIBILITY_LEVEL]
|[STD_HOURS_PER_DAY]|Number(9)| |Validation: May not exceed 24. Derivation: If not provided, [STD_HOURS_PER_DAY] will be derived from the value found on the indicated [WORK_RULE_CODE]. If this value is NULL, then the [STD_HOURS_PER_DAY] will be derived from the value found on the indicated [GROUP_CODE]. If this value is NULL, then the [STD_HOURS_PER_DAY] will be derived from the value found on the [JOB_CODE].
|[STD_HOURS_PER_WEEK]|Number(9)| |Validation: May not exceed 168. Derivation: If not provided, [STD_HOURS_PER_WEEK] will be derived from the value found on the indicated [WORK_RULE_CODE]. If this value is NULL, then the [STD_HOURS_PER_WEEK] will be derived from the value found on the indicated [GROUP_CODE]. If this value is NULL, then the [STD_HOURS_PER_WEEK] will be derived from the value found on the [JOB_CODE].
|[STD_HOURS_PER_PAY]|Number(9)| |Validation: May not exceed 744. Derivation: If not provided, [STD_HOURS_PER_PAY] will be derived from the value found on the indicated [WORK_RULE_CODE]. If this value is NULL, then the [STD_HOURS_PER_PAY] will be derived from the value found on the indicated [GROUP_CODE]. If this value is NULL, then the [STD_HOURS_PER_PAY] will be derived from the value found on the [JOB_CODE].
|[POSITION_POINTS]|Number(5)| |
|[USE_FTE_WAGES]|Varchar2(4)| |Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N”, “NO” or “0”. All other values will translate to True. Derivation: If not specified, this field will be derived from [USE_FTE_WAGES] as specified on the [P2K_CM_GROUP_DETAILS] record for the related job.
|[WAGE_RATE]|Number(18)| |Validation: May not be set to $0.00. Derivation: This field will be derived from the [WAGE_RATE] on the [P2K_SA_WAGE_SCALES], if a [SCALE_CODE] and [STEP_CODE] are provided. If not specified, the [WAGE_RATE] will then be derived from the [P2K_CM_JOB_DETAILS] record.
|[RATE_BASIS]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_RATE_BASIS]. Derivation: If not provided, [RATE_BASIS] will be derived from the value found on the indicated [SCALE_CODE] / [STEP_CODE]. If this value is NULL, then the [RATE_BASIS] will be derived from the value found on the indicated [JOB_CODE]. If this value is NULL, then the [RATE_BASIS] will be derived from the value found on the [RANGE_CODE]. Suggestion: Do not provide a Rate_Basis without a Wage_Rate, as the derived rate basis may not be the one you intend.
|[OVERTIME_EXEMPT]|Varchar2(4)| |Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N”, “NO” or “0”. All other values will translate to True. Derivation: If not specified, this field will be derived from [OVERTIME_EXEMPT] as specified on the [P2K_CM_JOB_DETAILS] record for the related job.
|[DIRECT_CHARGE]|Varchar2(4)| |Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N”, “NO” or “0”. All other values will translate to True. Derivation: If not specified, this field will be derived from [DIRECT_CHARGE] as specified on the [P2K_CM_JOB_DETAILS] record for the related job.
|[ASSIGNMENT_REQUIRED]|Varchar2(4)| |Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N”, “NO” or “0”. All other values will translate to True. Derivation: If not specified, this field will be derived from [ASSIGNMENT_REQUIRED] as specified on the [P2K_CM_JOB_DETAILS] record for the related job.
|[POSITION_STATUS]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from {X_POSITION_STATUS].
|[BUDGET_RULE]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_BUDGET_RULE].
|[AUTHORIZED_FTE]|Number(9)| |
|[FTE_OVERRIDE_RULE]|Varchar2(30)| |
|[APPROVED_DATE]|Date()| |Validation: Must be a valid date.
|[APPROVED_BY]|Varchar2(50)| |Suggestion: If you enter a value for this field, you should also set the STANDING to “A” – Active and enter a value for the APPROVED_DATE
|[LAST_REVIEW_DATE]|Date()| |Validation: Must be a valid date.
|[SUSPENDED_DATE]|Date()| |Validation: Must be a valid date. Suggestion: If you enter a value for this field, you should also set the STANDING to “O” – Obsolete
|[ABOLISHED_DATE]|Date()| |Validation: Must be a valid date. Suggestion: If you enter a value for this field, you should also set the STANDING to “O” – Obsolete
|[LEGISLATION]|Varchar2(30)| |
|[OCCUPATION_GROUP]|Varchar2(30)| |
|[OCCUPATION_CODE]|Varchar2(16)| |
|[INDUSTRY_CODE]|Varchar2(16)| |
|[DEFAULT_FTE]|Number(9)| |
|[JOB_PROFILE_CODE]|Varchar2(16)| |
|[PROVIDE_PUBLIC_SERVICE]|Varchar2(4)| |
|[PROVIDE_INTERNAL_SERVICE]|Varchar2(4)| |
|[SUPERVISORY]|Varchar2(4)| |
|[PAYDEST_LOCATION_CODE]|Varchar2(16)| |
|[PREMIUM_CODE]|Varchar2(16)| |Validation: Must be a valid premium defined on [P2K_SA_PREMIUMS], and may not have already been defined for this job, effective at the same time.
|[PREMIUM_RATE_BASIS|RATE_BASIS]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_RATE_BASIS]
|[PREMIUM_RATE]|Number(18)| |
|[SPLIT_SEQUENCE]|Number(5)| |
|[DISTRIBUTION_CODE]|Varchar2(50)| |Validation: The [DISTRIBUTION_CODE] is validated against the [DISTRIBUTION_FORMAT] specified for the GLCOMPANY that is associated with the [ENTITY_CODE_SUB_DIVISION|ENTITY_CODE].
|[SPLIT_RULE]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_SPLIT_RULE]
|[SPLIT_PERCENT]|Number(5)| |. This value should only be specified when you have a [SPLIT_RULE] set to “01” – Split by Percent
|[SPLIT_AMOUNT]|Number(18)| |This value should only be specified when you have a [SPLIT_RULE] set to “02” – Split by Amount
|[ADDITIONAL]|Varchar2(4)| |
|[START_DATE]|Date()| |
|[END_DATE]|Date()| |
|[GL_FUND_CODE]|Varchar2(16)| |
|[USER_PERCENT]|Number(5)| |
|[USER_FIELD_VALUE_01|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS01 defined on [IMUF]
|[USER_FIELD_VALUE_02|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS02 defined on [IMUF]
|[USER_FIELD_VALUE_03|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS03 defined on [IMUF]
|[USER_FIELD_VALUE_04|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS04 defined on [IMUF]
|[USER_FIELD_VALUE_05|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS05 defined on [IMUF]
|[USER_FIELD_VALUE_06|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS06 defined on [IMUF]
|[USER_FIELD_VALUE_07|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS07 defined on [IMUF]
|[USER_FIELD_VALUE_08|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS08 defined on [IMUF]
|[USER_FIELD_VALUE_09|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS09 defined on [IMUF]
|[USER_FIELD_VALUE_10|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS10 defined on [IMUF]
|[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
At line 6 removed one line
Position Interface File data is maintained on the [INF_CV_POSITIONS] table.
At line 8 changed 9 lines
\\ \\
;[ID|ID]:This field uniquely identifies the position record within the data base.
;[Position|POSITION_CODE]:This field identifies the position within the organization.
;[Position|POSITION_CODE_GROUPING]:
;[Entity|ENTITY_CODE]:This field displays the entity to which the position belongs.
;[Standing|STANDING]:Standing is used to indicate whether the record is active, frozen or obsolete.
;[Generic Position|GENERIC_CODE]:
;[Effective As Of|EFFECTIVE]/[Expires On|EXPIRY]:If the position is temporary, these field indicate the dates the job is effective.
;[Change Reason|CHANGE_CODE]:This field displays the ‘Change Reason’ code, which provides the rationale as to why information has been created or changed as of an effective date.
[{If var='loginstatus' contains 'authenticated'
At line 18 removed one line
\\ \\
At line 20 changed 19 lines
!!Definition
;[Title|POSITION_TITLE]:This field displays the official or formal title of the position, defaulted from the job title.
;[Description 1|DESCRIPTION_1]/[Description 2|DESCRIPTION_2]:These fields hold descriptions of the position.
;[Provide Public Service|PROVIDE_PUBLIC_SERVICE]:This field indicates if the position is to be reported as ‘Provide Public Service’ on specific government reports (e.g. Official Language Report - REOLA).
;[Provide Internal Service|PROVIDE_INTERNAL_SERVICE]:This field indicates if the position is to be reported as ‘Provide Internal Service’ on specific government reports (e.g. Official Language Report - REOLA).
;[Supervisory|SUPERVISORY]:This field indicates if the position is to be reported as ‘Supervisory’ on specific government reports (e.g. Official Language Report - REOLA).
;[Unit|UNIT_CODE]:This field displays the name of the unit to which this position belongs.
;[Department|DEPARTMENT_CODE]:This field displays the department in which the tasks take place.
;[Location|LOCATION_CODE]:This is the location where the tasks are being performed.
;[Group|GROUP_CODE]:This field displays the group to which the position belongs.
;[Job|JOB_CODE]:This field displays the job on which the position is based.
;[Person Code|PERSON_CODE]:This field identifies the employee associated with the position.
;[Range|RANGE_CODE]:This field provides range code associated with the position.
;[Work Rule|WORK_RULE (Field)]:Work rules are used to determine standard payroll processing information required to create pay headers and transactions for an employee.
;[Reports to Position|POSITION_CODE_REPORTING_TO]:This is the position to which this position reports.
;[Auth Area|AUTHORIZATION_CODE]:The authorization area is a security feature that enables an organization to control access to information for this position.
;[Scale|SCALE_CODE]:This field display the scale/step code that will be used to default to an employee's assignment record.
;[Type|POSITION_TYPE]:This field shows the type (i.e. executive, management, supervisory, etc.) of position being defined. This field is used in several legislated reports for the categorization of employees (EMIS, TWC).
;[Status|POSITION_STATUS]:This field indicates whether the position is approved, not approved or obsolete.
![Discussion|Edit:Internal.IVDPS]
[{InsertPage page='Internal.IVDPS' default='Click to create a new discussion page'}]
At line 40 changed 61 lines
\\ \\
----
!!Compensation
;[Scale|SCALE_CODE]/[Step|STEP_CODE]:These fields display the scale/step code that will be used to default to an employee's assignment record.
;[STD Hours Per Day|STD_HOURS_PER_DAY]:This field shows the standard hours per day required for this position.
;[Authorized FTE|AUTHORIZED_FTE]:This field displays the number of full time equivalent positions for which a commitment has been made by the organization
;[FTE Override Rule|FTE_OVERRIDE_RULE]:This is the warning rule to be used if the total FTE of a position exceeds the authorized FTE when placing an employee into the position.
;[Default FTE|DEFAULT_FTE]:This is the default full time equivalence of positions for which a commitment has been made by the organization.
;[STD Hours Per Week|STD_HOURS_PER_WEEK]:This field shows the standard hours per week required for this position.
;[STD Hours Per Pay|STD_HOURS_PER_PAY]:This field shows the standard hours per pay period required for this position.
;[Use FTE Wages|USE_FTE_WAGES]:This field indicates the FTE wage for the position.
;[Wage Rate|WAGE_RATE]:The wage rate for the position is displayed in this field.
;[Basis|RATE_BASIS]:The rate basis is the unit of measure in which the associate wage rate is being stored or displayed (i.e.hourly, weekly, biweekly, semi-monthly, monthly or annually).
\\ \\
----
!!Miscellaneous
;[Job Points|POSITION_POINTS]:For the purposes of using salary ranges ‘by formula’, position points may be assigned.
;[Overtime Exempt|OVERTIME_EXEMPT]:This field indicates if the position is eligible for overtime.
;[Direct Wages|DIRECT_CHARGE]:This field indicates whether all work done in this job is charged directly to a specific distribution (i.e. a work or job order, dept, cost center or account), regardless of who works on it
;[Assignment Required|ASSIGNMENT_REQUIRED]: If the toggle is ON, an employee must have a work assignment record (i.e. an authorization) that permits them to work in this position.
;[Approved On|APPROVED_DATE]:The date the approval was given is indicated in this field.
;[Approved By|APPROVED_BY]:This field indicates who gave the approval.
;[Last Reviewed On|LAST_REVIEW_DATE]:This date field indicates the last time the position was reviewed.
;[Suspended On|SUSPENDED_DATE]:This date field indicates when the position was suspended.
;[Abolished As Of|ABOLISHED_DATE]:This date field indicates when the position was abolished.
;[Legislation|LEGISLATION]:The legislation the entity falls under is displayed here.
;[Occupation Group|OCCUPATION_GROUP]:This field identifies the occupation group the position belongs to.
;[WC Class|WCB_CLASS]:This field shows the Workers’ Compensation classification used to determine the WC category for reporting and WC contribution.
;[Language Class|LANGUAGE_CLASS]:Language classification is used to record any special language requirements of a position.
;[Org Chart Level|ORG_CHART_LEVEL]:This field shows the level or tier of the organization chart on which this position should appear.
;[Responsibility Level|RESPONSIBILITY_LEVEL]:This field shows the responsibility level associated with the position.
;[Budget Rule|BUDGET_RULE]:This field indicates whether the position is budgeted, not budgeted or encumbered.
;[Occupation|OCCUPATION_CODE]:The occupation that the position is associated with is displayed in this field.
;[Industry|INDUSTRY_CODE]:The industry associated with the position is displayed in this field.
;[Job Profile|JOB_PROFILE_CODE]:The job profile associated with this position is displayed in this field.
;[Paydest Location Code|PAYDEST_LOCATION_CODE]:This field identifies the pay destination location.
\\ \\
----
!!Premiums & Distributions
;[Premium|PREMIUM_CODE]:This field identifies the premium associated with the position.
;[Basis|PREMIUM_RATE_BASIS]:The rate basis is the unit of measure in which the associated rate is being stored or displayed for the defaulted premium rate. For example: hourly, weekly, biweekly, semi-monthly, monthly, or annual.
;[Rate|PREMIUM_RATE]:This field shows the premium rate that is defaulted from this premium.
;[Seq #|SPLIT_SEQUENCE]:This field defines the sequential order of the distribution codes for this position
;[Distribution|DISTRIBUTION_CODE]:This field shows part or all of the distribution code receiving the portion of costs. This is normally the distribution of the wages associated with the position.
;[Split Rule|SPLIT_RULE]:The distribution split rule indicates whether the distribution is being split by a percentage, by flat amount or by a Distribution pick list of authorized assignments.
;[Percentage|SPLIT_PERCENT]:If the split rule is ‘by percent’ this field indicates the percent.
;[Amount $|SPLIT_AMOUNT]:If the split rule is ‘by amount’ then indicate the amount in this field.
;[Additional|ADDITIONAL]:
;[Start Date|START_DATE]/[End Dat|END_DATE]:If the premium is for a limited time, these fields indicate the start and end dates of that time period.
;[GL Fund Code|GL_FUND_CODE]:The GL fund associated with the premium is displayed in this field
;[User Percent|USER_PERCENT]:If ‘Split By Percent’ has been selected as the split rule, then the user percentage will be displayed in this field.
\\ \\
----
!!User Fields
;[Value 1 - 10|USER_FIELD_VALUE_nn]:This field is used for conversion. This value is applied against the user-defined field for each table which must have been previously defined in the [P2K_AM_USER_FIELDS] table.
----
![Notes|Edit:Internal.IVDPS]
[{InsertPage page='Internal.IVDPS' default='Click to create a new notes page'}]
}]
This page (revision-31) was last changed on 26-Nov-2021 10:22 by lurtanTop