INF_CV_POSITIONS
Back to current versionRestore this version

Alias: IVDPS#

(INF_CV_POSITIONS)

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.

Tables loaded:

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
ENTITY_CODEVarchar2(16)YValidation: Must be a valid entity code defined on P2K_CM_ENTITIES
POSITION_CODEVarchar2(16)YValidation: Must be a unique position code for the entity specified
STANDINGVarchar2(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_CODEVarchar2(4)
POSITION_CODE_GROUPINGVarchar2(16)
EFFECTIVEDate()YValidation: 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.
EXPIRYDate() 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_CODEVarchar2(16) Validation: The Change Code provided must be defined on P2K_CM_CHANGE_REASONS
UNIT_CODEVarchar2(16) Validation: Must be a valid entity code defined on P2K_CM_UNITS.
DEPARTMENT_CODEVarchar2(16) Validation: Must be a valid position code defined on P2K_CM_DEPARTMENTS.
LOCATION_CODEVarchar2(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_CODEVarchar2(16) Validation: Must be a valid GROUP_CODE defined on P2K_CM_GROUPS
JOB_CODEVarchar2(16) Validation: Must be a valid JOB_CODE defined on P2K_CM_JOBS
PERSON_CODEVarchar2(16) Validation: The PERSON_CODE must be for a valid employee currently entered on P2K_HR_IDENTITIES.
RANGE_CODEVarchar2(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 (Field)Varchar2(16) Validation: Must be a Work Rule Code defined on P2K_CM_WORK_RULES. Derivation: If not provided, WORK_RULE (Field) will be derived from the value found on the indicated group record P2K_CM_GROUP_DETAILS.
POSITION_CODE_REPORTING_TOVarchar2(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_CODEVarchar2(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_CODEVarchar2(16) Validation: Must be a valid scale code defined on P2K_SA_WAGE_SCALES
STEP_CODEVarchar2(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_TITLEVarchar2(50) Derivation: If not specified, this field will be derived from the JOB_TITLE for the specified JOB.
DESCRIPTION_1Varchar2(50)
DESCRIPTION_2Varchar2(50)
POSITION_TYPEVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_POSITION_TYPE
WCB_CLASSVarchar2(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_CLASSVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_LANGUAGE_CLASS
ORG_CHART_LEVELVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_ORG_CHART_LEVEL
RESPONSIBILITY_LEVELVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_RESPONSIBILITY_LEVEL
STD_HOURS_PER_DAYNumber(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 (Field). 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_WEEKNumber(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 (Field). 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_PAYNumber(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 (Field). 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_POINTSNumber(5)
USE_FTE_WAGESVarchar2(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_RATENumber(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_BASISVarchar2(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_EXEMPTVarchar2(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_CHARGEVarchar2(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_REQUIREDVarchar2(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_STATUSVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from {X_POSITION_STATUS].
BUDGET_RULEVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_BUDGET_RULE.
AUTHORIZED_FTENumber(9)
FTE_OVERRIDE_RULEVarchar2(30)
APPROVED_DATEDate() Validation: Must be a valid date.
APPROVED_BYVarchar2(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_DATEDate() Validation: Must be a valid date.
SUSPENDED_DATEDate() 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_DATEDate() Validation: Must be a valid date. Suggestion: If you enter a value for this field, you should also set the STANDING to “O” – Obsolete
LEGISLATIONVarchar2(30)
OCCUPATION_GROUPVarchar2(30)
OCCUPATION_CODEVarchar2(16)
INDUSTRY_CODEVarchar2(16)
DEFAULT_FTENumber(9)
JOB_PROFILE_CODEVarchar2(16)
PROVIDE_PUBLIC_SERVICEVarchar2(4)
PROVIDE_INTERNAL_SERVICEVarchar2(4)
SUPERVISORYVarchar2(4)
PAYDEST_LOCATION_CODEVarchar2(16)
PREMIUM_CODEVarchar2(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_BASISVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_RATE_BASIS
PREMIUM_RATENumber(18)
SPLIT_SEQUENCENumber(5)
DISTRIBUTION_CODEVarchar2(50) Validation: The DISTRIBUTION_CODE is validated against the DISTRIBUTION_FORMAT specified for the GLCOMPANY that is associated with the ENTITY_CODE_SUB_DIVISION.
SPLIT_RULEVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_SPLIT_RULE
SPLIT_PERCENTNumber(5) . This value should only be specified when you have a SPLIT_RULE set to “01” – Split by Percent
SPLIT_AMOUNTNumber(18) This value should only be specified when you have a SPLIT_RULE set to “02” – Split by Amount
ADDITIONALVarchar2(4) Four character alphanumeric field used to enter additional information.
START_DATEDate()
END_DATEDate()
GL_FUND_CODEVarchar2(16)
USER_PERCENTNumber(5)
USER_FIELD_VALUE_01Varchar2(2000) Looking for DPS01 defined on IMUF
USER_FIELD_VALUE_02Varchar2(2000) Looking for DPS02 defined on IMUF
USER_FIELD_VALUE_03Varchar2(2000) Looking for DPS03 defined on IMUF
USER_FIELD_VALUE_04Varchar2(2000) Looking for DPS04 defined on IMUF
USER_FIELD_VALUE_05Varchar2(2000) Looking for DPS05 defined on IMUF
USER_FIELD_VALUE_06Varchar2(2000) Looking for DPS06 defined on IMUF
USER_FIELD_VALUE_07Varchar2(2000) Looking for DPS07 defined on IMUF
USER_FIELD_VALUE_08Varchar2(2000) Looking for DPS08 defined on IMUF
USER_FIELD_VALUE_09Varchar2(2000) Looking for DPS09 defined on IMUF
USER_FIELD_VALUE_10Varchar2(2000) Looking for DPS10 defined on IMUF
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
POSITION_TITLE_TRANSVARCHAR2(4000)
TRANS_LANGUAGEVARCHAR2(30)


Notes #

Click to create a new notes page