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

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
7 26-Nov-2021 10:22 4 KB jmyers to previous WORK_RULE_CODE ==> WORK_RULE (Field)
6 26-Nov-2021 10:22 4 KB JMyers to previous | to last
5 26-Nov-2021 10:22 17 KB JMyers to previous | to last
4 26-Nov-2021 10:22 17 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed 2 lines
[{TableOfContents }]
!!!POSTINGS INTERFACE FILE
!!!Alias: [IVRPO]
(INF_CV_POSTINGS)
\\
At line 4 changed one line
The Posting Interface File screen is used to import posting records into the software data structures.
Postings
At line 6 changed one line
Posting Interface File data is maintained on the [INF_CV_POSTINGS] table.
!!Table Columns
At line 8 changed 53 lines
----
!!Tab 1
;[ID|ID]:This field identifies the posting record within the data base.
;[Entity|ENTITY_CODE]:This field displays the entity that is generating the postings.
;[Posting|POSTING_CODE]:This field identifies the postings.
;[Job Profile|JOB_PROFILE_CODE]:The job profile associated with this posting will be displayed in this field.
;[Person Code|PERSON_CODE]:The person associated with this posting will be displayed in this field.
;[Employment Type|EMPLOYMENT_TYPE]:This field allows you to define the type of the employment for the assignment.
;[Date of Hire|HIRE_DATE]:The date of hire associated with the assignment is displayed in this field.
;[Assignment|ASSIGNMENT_CODE]:The assignment associated with the posting is displayed in this field.
;[Assignment Start Date|ASSIGNMENT_START_DATE]:If the assignment is date sensitive, the first date of the assignment will be indicated in this field.
;[Posting Title|POSTING_TITLE]:This field displays a descriptive title of the posting.
;[Status|POSTING_STATUS]:This field will display the status of the postings.
;[Department|DEPARTMENT_CODE]:This field will display the department associated with this postings.
;[Location|LOCATION_CODE]:This field will display the location associated with this postings.
;[Unit|UNIT_CODE]:This field will display the unit associated with this postings.
;[Group|GROUP_CODE]:This field will display the group associated with this postings.
;[Work Rule|WORK_RULE (Field)]:This field will display the work rule associated with this postings.
;[Job|JOB_CODE]:This field will display the job associated with this postings.
;[Position|POSITION_CODE]:This field will display the position associated to this postings.
;[Range|RANGE_CODE]:This field will show the salary range for this assignment.
;[Scale|SCALE_CODE]:This field will show the wage scale for this assignment.
\\
----
!!Tab 2
;[Recruiters|RECRUITER_CODE]:You may use this field to identify the recruiter for this postings.
;[Approved|APPROVED]:This field will indicated if the posting has been approved.
;[Source|POSTING_SOURCE]:This field provides a reason for the postings.
;[Type|POSTING_TYPE]:This field defines the nature of the postings.
;[Category|POSTING_CATEGORY]:This field classifies the postings into a specific group.
;[Priority|POSTING_PRIORITY]:The priority of the postings will be shown in this field.
;[Required FTE|REQUIRED_FTE]:This field will show the FTE required for this postings.
;[Default FTE|DEFAULT_FTE]:This field shows the default FTE for this position used for forecasting and costing.
;[Filled FTE|FILLED_FTE]:If this posting has been filled, this field will show the amount of FTE that has been filled.
;[Date of Requisition|REQUISITION_DATE]:This field will display the date for this [requisition|REQUISITIONS] was created.
;[Internally Opened On|INTERNAL_POSTING_OPENED]:This field will display the date the postings was open to internal candidates.
;[General Posting Opened|GENERAL_POSTING_OPENED]:This field displays the date the postings was opened to external candidates.
;[Posting Closed On|POSTING_CLOSED]:This field displays the date the postings was closed to new applicants.
;[Posting Filled As Of|POSTING_FILLED]:If the postings been filled, this field will display the date a candidate was hired.
;[Employment Type|POSTING_EMPLOYMENT_TYPE]:The employment type associated with the posting will be displayed in this field.
;[Group Type|GROUP_TYPE]:This field displays the type of group for this assignment.
;[Responsibility Level|RESPONSIBILITY_LEVEL]:This field identifies the level of responsibility for the assignment.
;[Language Class|LANGUAGE_CLASS]:This field identifies the language(s) used in this assignment.
;[WC Class|WCB_CLASS]:This field identifies the workers compensation for this assignment.
;[Work Type|WORK_TYPE]:This field further groups the assignment into work types.
\\
----
!!Tab 3
;[Start Date|POSTING_ASSIGNMENT_START_DATE]/[End Date|ASSIGNMENT_END_DATE]:If the assignment is date sensitive, the first and last dates of the assignment will be indicated in these fields.
;[Hours Per Day|HOURS_PER_DAY]:This field shows the average daily hours associated with this assignment.
;[Hours Per Week|HOURS_PER_WEEK]:This field shows the average weekly hours associated with this assignment.
;[Wage Rate|WAGE_RATE]:This field will show the wage rate for this assignment.
;[Basis|RATE_BASIS]:This field shows the rate basis that the wage is expressed in.
||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|
|[POSTING_CODE]|Varchar2(16)|Y|
|[JOB_PROFILE_CODE]|Varchar2(16)|Y|
|[PERSON_CODE]|Varchar2(16)|Y|
|[EMPLOYMENT_TYPE]|Varchar2(30)|Y|
|[HIRE_DATE]|Date()|Y|
|[ASSIGNMENT_CODE]|Varchar2(16)|Y|
|[ASSIGNMENT_START_DATE]|Date()|Y|
|[POSTING_TITLE]|Varchar2(50)|Y|
|[POSTING_STATUS]|Varchar2(30)|Y|
|[DEPARTMENT_CODE]|Varchar2(16)| |
|[LOCATION_CODE]|Varchar2(16)| |
|[UNIT_CODE]|Varchar2(16)| |
|[GROUP_CODE]|Varchar2(16)| |
|[WORK_RULE_CODE]|Varchar2(16)| |
|[JOB_CODE]|Varchar2(16)| |
|[POSITION_CODE]|Varchar2(16)| |
|[RANGE_CODE]|Varchar2(16)| |
|[SCALE_CODE]|Varchar2(16)| |
|[RECRUITER_CODE]|Varchar2(16)| |
|[APPROVED]|Varchar2(4)| |
|[POSTING_SOURCE]|Varchar2(30)| |
|[POSTING_TYPE]|Varchar2(30)| |
|[POSTING_CATEGORY]|Varchar2(30)| |
|[POSTING_PRIORITY]|Varchar2(30)| |
|[REQUIRED_FTE]|Number(9)| |
|[DEFAULT_FTE]|Number(9)| |
|[FILLED_FTE]|Number(9)| |
|[REQUISITION_DATE]|Date()| |
|[INTERNAL_POSTING_OPENED]|Date()| |
|[GENERAL_POSTING_OPENED]|Date()| |
|[POSTING_CLOSED]|Date()| |
|[POSTING_FILLED]|Date()| |
|[POSTING_EMPLOYMENT_TYPE]|Varchar2(30)| |
|[GROUP_TYPE]|Varchar2(30)| |
|[RESPONSIBILITY_LEVEL]|Varchar2(30)| |
|[LANGUAGE_CLASS]|Varchar2(30)| |
|[WCB_CLASS]|Varchar2(30)| |
|[WORK_TYPE]|Varchar2(30)| |
|[POSTING_ASSIGNMENT_START_DATE]|Date()| |
|[ASSIGNMENT_END_DATE]|Date()| |
|[HOURS_PER_DAY]|Number(9)| |
|[HOURS_PER_WEEK]|Number(9)| |
|[WAGE_RATE]|Number(18)| |
|[RATE_BASIS]|Varchar2(30)| |
At line 58 added 3 lines
[{If var='loginstatus' contains 'authenticated'
At line 64 changed 2 lines
![Notes|Edit:Internal.IVRPO]
[{InsertPage page='Internal.IVRPO' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IVRPO]
[{InsertPage page='Internal.IVRPO' default='Click to create a new discussion page'}]
}]