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 one line
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.
[{TableOfContents }]
!!!Position INTERFACE FILE
The Position Interface File screen is used to import position codes into the software data structures.
Position Interface File data is maintained on the [INF_CV_POSITIONS] table.
\\ \\
;[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.
At line 4 changed 20 lines
!!Tab 1
;[ID|ID]:
;[Entity|ENTITY_CODE]:
;[Position|POSITION_CODE]:
;[Standing|STANDING]:
;[|GENERIC_CODE]:
;[|POSITION_CODE_GROUPING]:
;[Effective As Of|EFFECTIVE]:
;[Expires On|EXPIRY]:
;[Change Reason|CHANGE_CODE]:
;[Unit|UNIT_CODE]:
;[Department|DEPARTMENT_CODE]:
;[Location|LOCATION_CODE]:
;[Group|GROUP_CODE]:
;[Job|JOB_CODE]:
;[Person Code|PERSON_CODE]:
;[Range|RANGE_CODE]:
;[Work Rule|WORK_RULE_CODE]:
;[Reports to Position|POSITION_CODE_REPORTING_TO]:
;[Authorization Area|AUTHORIZATION_CODE]:
!!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.
At line 26 changed 21 lines
!!Tab 2
;[Scale|SCALE_CODE]/[Step|STEP_CODE]:
;[Title|POSITION_TITLE]:
;[Description 1|DESCRIPTION_1]:
;[Description 2|DESCRIPTION_2]:
;[Position Type|POSITION_TYPE]:
;[WC Class|WCB_CLASS]:
;[Language Class|LANGUAGE_CLASS]:
;[Org Chart Level|ORG_CHART_LEVEL]:
;[Responsibility Level|RESPONSIBILITY_LEVEL]:
;[STD Hours Per Day|STD_HOURS_PER_DAY]:
;[STD Hours Per Week|STD_HOURS_PER_WEEK]:
;[STD Hours Per Pay|STD_HOURS_PER_PAY]:
;[Job Points|POSITION_POINTS]:
;[Use FTE Wages|USE_FTE_WAGES]:
;[Wage Rate|WAGE_RATE]:
;[Basis|RATE_BASIS]:
;[Overtime Exempt|OVERTIME_EXEMPT]:
;[Direct Wages|DIRECT_CHARGE]:
;[Assignment Required|ASSIGNMENT_REQUIRED]:
;[Status|POSITION_STATUS]:
!!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).
At line 49 changed 21 lines
!!Tab 3
;[Budget Rule|BUDGET_RULE]:
;[Authorized FTE|AUTHORIZED_FTE]:
;[FTE Override Rule|FTE_OVERRIDE_RULE]:
;[Approved On|APPROVED_DATE]:
;[Approved By|APPROVED_BY]:
;[Last Reviewed On|LAST_REVIEW_DATE]:
;[Suspended On|SUSPENDED_DATE]:
;[Abolished As Of|ABOLISHED_DATE]:
;[Legislation|LEGISLATION]:
;[Occupation Group|OCCUPATION_GROUP]:
;[Occupation|OCCUPATION_CODE]:
;[Industry|INDUSTRY_CODE]:
;[Default FTE|DEFAULT_FTE]:
;[Job Profile|JOB_PROFILE_CODE]:
;[Provide Public Service|PROVIDE_PUBLIC_SERVICE]:
;[Provide Internal Service|PROVIDE_INTERNAL_SERVICE]:
;[Supervisory|SUPERVISORY]:
;[Paydest Location Code|PAYDEST_LOCATION_CODE]:
;[Premium|PREMIUM_CODE]:
;[Premium Basis|PREMIUM_RATE_BASIS|RATE_BASIS]:
!!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.
At line 72 changed 17 lines
!!Tab 4
;[Premium Rate|PREMIUM_RATE]:
;[Seq #|SPLIT_SEQUENCE]:
;[Distribution|DISTRIBUTION_CODE]:
;[Split Rule|SPLIT_RULE]:
;[Percentage|SPLIT_PERCENT]:
;[Amount $|SPLIT_AMOUNT]:
;[Additional|ADDITIONAL]:
;[Start Date|START_DATE]:
;[End Dat|END_DATE]:
;[GL Fund|GL_FUND_CODE]:
;[User Percent|USER_PERCENT]:
;[User Field Value 1 - 10|USER_FIELD_VALUE_nn]:
[{If var='loginstatus' contains 'authenticated'
!!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.
\\ \\
At line 90 changed 2 lines
![Discussion|Edit:Internal.IVDPS]
[{InsertPage page='Internal.IVDPS' default='Click to create a new discussion page'}]
!!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.
At line 93 changed one line
}]
----
![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