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_CANDIDATES
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.7 mins, 150 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
6
7
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVRCA
#
(INF_CV_CANDIDATES)
Candidates
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
CANDIDATE_CODE
Varchar2(16)
CODE
Y
DATE_SUBMITTED
Date()
DATE
Y
CANDIDATE_STATUS
Varchar2(30)
VARCHAR30
Y
RECRUITER_CODE
Varchar2(16)
CODE
PERSON_CODE_EMPLOYEE
Varchar2(16)
CODE
PERSON_CODE_REFERRAL
Varchar2(16)
CODE
COUNTRY_CODE
Varchar2(16)
CODE
STATE_PROVINCE_CODE
Varchar2(16)
CODE
GEO_CODE
Varchar2(16)
CODE
SCHOOL_DISTRICT_CODE
Varchar2(16)
CODE
CANDIDATE_TYPE
Varchar2(30)
VARCHAR30
CANDIDATE_CATEGORY
Varchar2(30)
VARCHAR30
CURRENT_EMPLOYER
Varchar2(50)
DESCRIPTION
CURRENT_TITLE
Varchar2(50)
DESCRIPTION
CANDIDATE_SOURCE
Varchar2(30)
VARCHAR30
CANDIDATE_PASSWORD
Varchar2(16)
VARCHAR16
PASSWORD_CHANGED_DATE
Date()
DATE
PASSWORD_CHANGED_BY
Varchar2(50)
VARCHAR50
EXTERNAL_CANDIDATE_ID
Varchar2(16)
VARCHAR16
GOVT_CODE_VERIFIED
Varchar2(4)
VARCHAR4
APPLICATION_START_DATE
Date()
DATE
APPLICATION_END_DATE
Date()
DATE
AVAILABILITY_DATE
Date()
DATE
FIRST_NAME
Varchar2(50)
VARCHAR50
MIDDLE_NAME
Varchar2(50)
VARCHAR50
LAST_NAME
Varchar2(50)
VARCHAR50
SALUTATION
Varchar2(30)
VARCHAR30
RANK
Varchar2(30)
VARCHAR30
BIRTH_DATE
Date()
DATE
BIRTHPLACE
Varchar2(50)
VARCHAR50
GENDER
Varchar2(30)
VARCHAR30
LANGUAGE_CODE
Varchar2(30)
VARCHAR30
ETHNIC
Varchar2(30)
VARCHAR30
CHALLENGED
Varchar2(30)
VARCHAR30
VETERAN_STATUS
Varchar2(30)
VARCHAR30
ADDRESS_LINE_1
Varchar2(50)
ADDRESS
ADDRESS_LINE_2
Varchar2(50)
ADDRESS
LOCALITY
Varchar2(50)
ADDRESS
ZIP_POSTAL
Varchar2(16)
POSTAL CODE
MAIL_ADDRESS_LINE_1
Varchar2(50)
ADDRESS
MAIL_ADDRESS_LINE_2
Varchar2(50)
ADDRESS
MAIL_LOCALITY
Varchar2(50)
ADDRESS
STATE_PROVINCE_CODE_MAIL
Varchar2(16)
CODE
MAIL_ZIP_POSTAL
Varchar2(16)
POSTAL CODE
PHONE_UNLISTED
Varchar2(4)
VARCHAR4
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
CELLULAR_NUMBER
Varchar2(20)
TELEPHONE
EMAIL_ADDRESS
Varchar2(50)
EMAIL
MARITAL_STATUS
Varchar2(30)
VARCHAR30
MARRIED_DATE
Date()
DATE
NUMBER_DEPENDENTS
Number(5)
NUMBER5
TRANSPORTATION
Varchar2(30)
VARCHAR30
YEARS_EDUCATION
Number(5)
NUMBER5
BONDED_STATUS
Varchar2(30)
VARCHAR30
CITIZEN_STATUS
Varchar2(30)
VARCHAR30
FOREIGN_CODE
Varchar2(16)
CODE
DRIVERS_LICENSE
Varchar2(30)
LICENSE
PA_NUMBER
Number(10)
NUMBER10
PA_EFFECTIVE_DATE
Date()
DATE
GOVT_CODE_ORIGIN
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