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
