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_POSTINGS
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.5 mins, 103 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVRPO
#
(INF_CV_POSTINGS)
Postings
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
ENTITY_CODE
Varchar2(16)
CODE
Y
POSTING_CODE
Varchar2(16)
CODE
Y
JOB_PROFILE_CODE
Varchar2(16)
CODE
Y
PERSON_CODE
Varchar2(16)
CODE
Y
EMPLOYMENT_TYPE
Varchar2(30)
VARCHAR30
Y
HIRE_DATE
Date()
DATE
Y
ASSIGNMENT_CODE
Varchar2(16)
CODE
Y
ASSIGNMENT_START_DATE
Date()
DATE
Y
POSTING_TITLE
Varchar2(50)
DESCRIPTION
Y
POSTING_STATUS
Varchar2(30)
VARCHAR30
Y
DEPARTMENT_CODE
Varchar2(16)
CODE
LOCATION_CODE
Varchar2(16)
CODE
UNIT_CODE
Varchar2(16)
CODE
GROUP_CODE
Varchar2(16)
CODE
WORK_RULE_CODE
Varchar2(16)
CODE
JOB_CODE
Varchar2(16)
CODE
POSITION_CODE
Varchar2(16)
CODE
RANGE_CODE
Varchar2(16)
CODE
SCALE_CODE
Varchar2(16)
CODE
RECRUITER_CODE
Varchar2(16)
CODE
APPROVED
Varchar2(4)
VARCHAR4
POSTING_SOURCE
Varchar2(30)
VARCHAR30
POSTING_TYPE
Varchar2(30)
VARCHAR30
POSTING_CATEGORY
Varchar2(30)
VARCHAR30
POSTING_PRIORITY
Varchar2(30)
VARCHAR30
REQUIRED_FTE
Number(9)
AMT5V4
DEFAULT_FTE
Number(9)
AMT5V4
FILLED_FTE
Number(9)
AMT5V4
REQUISITION_DATE
Date()
DATE
INTERNAL_POSTING_OPENED
Date()
DATE
GENERAL_POSTING_OPENED
Date()
DATE
POSTING_CLOSED
Date()
DATE
POSTING_FILLED
Date()
DATE
POSTING_EMPLOYMENT_TYPE
Varchar2(30)
VARCHAR30
GROUP_TYPE
Varchar2(30)
VARCHAR30
RESPONSIBILITY_LEVEL
Varchar2(30)
VARCHAR30
LANGUAGE_CLASS
Varchar2(30)
VARCHAR30
WCB_CLASS
Varchar2(30)
VARCHAR30
WORK_TYPE
Varchar2(30)
VARCHAR30
POSTING_ASSIGNMENT_START_DATE
Date()
DATE
ASSIGNMENT_END_DATE
Date()
DATE
HOURS_PER_DAY
Number(9)
AMT5V4
HOURS_PER_WEEK
Number(9)
AMT5V4
WAGE_RATE
Number(18)
AMT12V6
RATE_BASIS
Varchar2(30)
VARCHAR30
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