Personality Knowledgebase 5.05
HighLine
Wiki
G’day (anonymous guest)
User Preferences
Log in
Register a new user!
For full search, hit enter...
Recent Searches
INF_CV_POSITIONS
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.8 mins, 186 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
6
7
8
9
10
11
12
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVDPS
#
(INF_CV_POSITIONS)
Holds Date Effective information about a position.
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
ENTITY_CODE
Varchar2(16)
CODE
Y
POSITION_CODE
Varchar2(16)
CODE
Y
STANDING
Varchar2(30)
VARCHAR30
GENERIC_CODE
Varchar2(4)
VARCHAR4
POSITION_CODE_GROUPING
Varchar2(16)
CODE
EFFECTIVE
Date()
EFFECTIVE
Y
EXPIRY
Date()
EXPIRY
CHANGE_CODE
Varchar2(16)
CODE
UNIT_CODE
Varchar2(16)
CODE
DEPARTMENT_CODE
Varchar2(16)
CODE
LOCATION_CODE
Varchar2(16)
CODE
GROUP_CODE
Varchar2(16)
CODE
JOB_CODE
Varchar2(16)
CODE
PERSON_CODE
Varchar2(16)
CODE
RANGE_CODE
Varchar2(16)
CODE
WORK_RULE_CODE
Varchar2(16)
CODE
POSITION_CODE_REPORTING_TO
Varchar2(16)
CODE
AUTHORIZATION_CODE
Varchar2(16)
CODE
SCALE_CODE
Varchar2(16)
CODE
STEP_CODE
Varchar2(16)
CODE
POSITION_TITLE
Varchar2(50)
DESCRIPTION
DESCRIPTION_1
Varchar2(50)
DESCRIPTION
DESCRIPTION_2
Varchar2(50)
DESCRIPTION
POSITION_TYPE
Varchar2(30)
VARCHAR30
WCB_CLASS
Varchar2(30)
VARCHAR30
LANGUAGE_CLASS
Varchar2(30)
VARCHAR30
ORG_CHART_LEVEL
Varchar2(30)
VARCHAR30
RESPONSIBILITY_LEVEL
Varchar2(30)
VARCHAR30
STD_HOURS_PER_DAY
Number(9)
AMT5V4
STD_HOURS_PER_WEEK
Number(9)
AMT5V4
STD_HOURS_PER_PAY
Number(9)
AMT5V4
POSITION_POINTS
Number(5)
NUMBER5
USE_FTE_WAGES
Varchar2(4)
VARCHAR4
WAGE_RATE
Number(18)
AMT12V6
RATE_BASIS
Varchar2(30)
VARCHAR30
OVERTIME_EXEMPT
Varchar2(4)
VARCHAR4
DIRECT_CHARGE
Varchar2(4)
VARCHAR4
ASSIGNMENT_REQUIRED
Varchar2(4)
VARCHAR4
POSITION_STATUS
Varchar2(30)
VARCHAR30
BUDGET_RULE
Varchar2(30)
VARCHAR30
AUTHORIZED_FTE
Number(9)
AMT5V4
FTE_OVERRIDE_RULE
Varchar2(30)
VARCHAR30
APPROVED_DATE
Date()
DATE
APPROVED_BY
Varchar2(50)
VARCHAR50
LAST_REVIEW_DATE
Date()
DATE
SUSPENDED_DATE
Date()
DATE
ABOLISHED_DATE
Date()
DATE
LEGISLATION
Varchar2(30)
VARCHAR30
OCCUPATION_GROUP
Varchar2(30)
VARCHAR30
OCCUPATION_CODE
Varchar2(16)
CODE
INDUSTRY_CODE
Varchar2(16)
CODE
DEFAULT_FTE
Number(9)
AMT5V4
JOB_PROFILE_CODE
Varchar2(16)
CODE
PROVIDE_PUBLIC_SERVICE
Varchar2(4)
VARCHAR4
PROVIDE_INTERNAL_SERVICE
Varchar2(4)
VARCHAR4
SUPERVISORY
Varchar2(4)
VARCHAR4
PAYDEST_LOCATION_CODE
Varchar2(16)
CODE
PREMIUM_CODE
Varchar2(16)
CODE
PREMIUM_RATE_BASIS
Varchar2(30)
VARCHAR30
PREMIUM_RATE
Number(18)
AMT12V6
SPLIT_SEQUENCE
Number(5)
NUMBER5
DISTRIBUTION_CODE
Varchar2(50)
DISTRIBUTION
SPLIT_RULE
Varchar2(30)
VARCHAR30
SPLIT_PERCENT
Number(5)
PERCENT
SPLIT_AMOUNT
Number(18)
AMT12V6
ADDITIONAL
Varchar2(4)
VARCHAR4
START_DATE
Date()
DATE
END_DATE
Date()
DATE
GL_FUND_CODE
Varchar2(16)
CODE
USER_PERCENT
Number(5)
PERCENT
USER_FIELD_VALUE_01
Varchar2(2000)
VARCHAR2000
USER_FIELD_VALUE_02
Varchar2(2000)
VARCHAR2000
USER_FIELD_VALUE_03
Varchar2(2000)
VARCHAR2000
USER_FIELD_VALUE_04
Varchar2(2000)
VARCHAR2000
USER_FIELD_VALUE_05
Varchar2(2000)
VARCHAR2000
USER_FIELD_VALUE_06
Varchar2(2000)
VARCHAR2000
USER_FIELD_VALUE_07
Varchar2(2000)
VARCHAR2000
USER_FIELD_VALUE_08
Varchar2(2000)
VARCHAR2000
USER_FIELD_VALUE_09
Varchar2(2000)
VARCHAR2000
USER_FIELD_VALUE_10
Varchar2(2000)
VARCHAR2000
CREATE_DATE
Date()
DATE
CREATE_USER
Varchar2(30)
VARCHAR30
CHANGE_DATE
Date()
DATE
CHANGE_USER
Varchar2(30)
VARCHAR30
Hello, 10.86.0.2
Index
Recent Updates
Wiki Formatting
Search Help