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.
- ID|
- |Varchar2(16)|Y|Validation
- Must be a valid entity code defined on P2K_CM_ENTITIES
- |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”.
- |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.
- |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.
- |Varchar2(16)| |Validation
- The Change Code provided must be defined on P2K_CM_CHANGE_REASONS
- |Varchar2(16)| |Validation
- Must be a valid entity code defined on P2K_CM_UNITS.
- |Varchar2(16)| |Validation
- Must be a valid position code defined on P2K_CM_DEPARTMENTS.
- |Varchar2(16)| |Validation
- Must be a valid GROUP_CODE defined on P2K_CM_GROUPS
- |Varchar2(16)| |Validation
- Must be a valid JOB_CODE defined on P2K_CM_JOBS
- |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
- |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.
- |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.
- |Varchar2(16)| |Validation
- Must be a valid scale code defined on P2K_SA_WAGE_SCALES
- |Varchar2(30)| |Validation
- Must be either a valid lexicon code, or a valid lexicon description from X_LANGUAGE_CLASS
- |Varchar2(30)| |Validation
- Must be either a valid lexicon code, or a valid lexicon description from X_ORG_CHART_LEVEL
- |Varchar2(30)| |Validation
- Must be either a valid lexicon code, or a valid lexicon description from X_RESPONSIBILITY_LEVEL
- |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
- |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
- |Varchar2(30)| |Validation
- If provided, must be one of the fixed lexicon values from X_RATE_BASIS
- Varchar2(2000)| |Looking for DPS02 defined on IMUF
- |Varchar2(2000)| |Looking for DPS03 defined on IMUF
- |Varchar2(2000)| |Looking for DPS04 defined on IMUF
- |Varchar2(2000)| |Looking for DPS05 defined on IMUF
- |Varchar2(2000)| |Looking for DPS06 defined on IMUF
- |Varchar2(2000)| |Looking for DPS07 defined on IMUF
- |Varchar2(2000)| |Looking for DPS08 defined on IMUF
- |Varchar2(2000)| |Looking for DPS09 defined on IMUF
- |Varchar2(2000)| |Looking for DPS10 defined on IMUF
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation