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_WORKHISTORIES
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.4 mins, 91 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
6
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVRWH
#
(INF_CV_WORKHISTORIES)
Work Histories
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
CANDIDATE_CODE
Varchar2(16)
CODE
Y
COMPANY_NAME
Varchar2(50)
VARCHAR50
Y
COUNTRY_CODE
Varchar2(16)
CODE
STATE_PROVINCE_CODE
Varchar2(16)
CODE
INDUSTRY_CODE
Varchar2(16)
CODE
VERIFIED_STATUS
Varchar2(30)
VARCHAR30
DATE_VERIFIED
Date()
DATE
CONTACT_NAME
Varchar2(50)
VARCHAR50
CONTACT_TITLE
Varchar2(50)
DESCRIPTION
ADDRESS_LINE_1
Varchar2(50)
ADDRESS
ADDRESS_LINE_2
Varchar2(50)
ADDRESS
LOCALITY
Varchar2(50)
ADDRESS
ZIP_POSTAL
Varchar2(16)
POSTAL CODE
PHONE_NUMBER
Varchar2(20)
TELEPHONE
PHONE_EXTENSION
Varchar2(16)
VARCHAR16
ALT_PHONE_NUMBER
Varchar2(20)
TELEPHONE
ALT_PHONE_EXTENSION
Varchar2(16)
VARCHAR16
FAX_NUMBER
Varchar2(20)
TELEPHONE
EMAIL_ADDRESS
Varchar2(50)
EMAIL
LANGUAGE_CODE
Varchar2(30)
VARCHAR30
COMPANY_SIZE
Varchar2(30)
VARCHAR30
EMPLOYMENT_TYPE
Varchar2(30)
VARCHAR30
GROUP_TYPE
Varchar2(30)
VARCHAR30
RESPONSIBILITY_LEVEL
Varchar2(30)
VARCHAR30
JOB_CATEGORY
Varchar2(30)
VARCHAR30
ASSIGNMENT_TITLE
Varchar2(50)
DESCRIPTION
ASSIGNMENT_START_DATE
Date()
DATE
ASSIGNMENT_END_DATE
Date()
DATE
REASON_FOR_LEAVING
Varchar2(30)
VARCHAR30
HOURS_PER_DAY
Number(9)
AMT5V4
HOURS_PER_WEEK
Number(9)
AMT5V4
WAGE_RATE
Number(18)
AMT12V6
RATE_BASIS
Varchar2(30)
VARCHAR30
AVAILABLE_TO_CONTACT
Varchar2(4)
VARCHAR4
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