This page (revision-14) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
14 26-Nov-2021 10:22 6 KB kparrott to previous
13 26-Nov-2021 10:22 6 KB rforbes to previous | to last
12 26-Nov-2021 10:22 6 KB jmyers to previous | to last
11 26-Nov-2021 10:22 6 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
10 26-Nov-2021 10:22 6 KB JMyers to previous | to last
9 26-Nov-2021 10:22 6 KB JMyers to previous | to last
8 26-Nov-2021 10:22 6 KB JMyers to previous | to last
7 26-Nov-2021 10:22 6 KB JMyers to previous | to last
6 26-Nov-2021 10:22 30 KB JMyers to previous | to last
5 26-Nov-2021 10:22 30 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 2 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
IVRCA
IVRCA

Version management

Difference between version and

At line 1 changed 3 lines
!!!Alias: IVRCA
(INF_CV_CANDIDATES)
\\
!!!CANDIDATE INTERFACE FILE
At line 5 changed one line
Candidates
The Candidate Interface File screen is used to import candidate records into the software data structures.
At line 7 changed one line
!!Table Columns
Candidate Interface File data is maintained on the [INF_CV_CANDIDATES] table.
At line 9 changed 66 lines
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[CANDIDATE_CODE]|Varchar2(16)|Y|
|[DATE_SUBMITTED]|Date()|Y|
|[CANDIDATE_STATUS]|Varchar2(30)|Y|
|[RECRUITER_CODE]|Varchar2(16)| |
|[PERSON_CODE_EMPLOYEE]|Varchar2(16)| |
|[PERSON_CODE_REFERRAL]|Varchar2(16)| |
|[COUNTRY_CODE]|Varchar2(16)| |
|[STATE_PROVINCE_CODE]|Varchar2(16)| |
|[GEO_CODE]|Varchar2(16)| |
|[SCHOOL_DISTRICT_CODE]|Varchar2(16)| |
|[CANDIDATE_TYPE]|Varchar2(30)| |
|[CANDIDATE_CATEGORY]|Varchar2(30)| |
|[CURRENT_EMPLOYER]|Varchar2(50)| |
|[CURRENT_TITLE]|Varchar2(50)| |
|[CANDIDATE_SOURCE]|Varchar2(30)| |
|[CANDIDATE_PASSWORD]|Varchar2(16)| |
|[PASSWORD_CHANGED_DATE]|Date()| |
|[PASSWORD_CHANGED_BY]|Varchar2(50)| |
|[EXTERNAL_CANDIDATE_ID]|Varchar2(16)| |
|[GOVT_CODE_VERIFIED]|Varchar2(4)| |
|[APPLICATION_START_DATE]|Date()| |
|[APPLICATION_END_DATE]|Date()| |
|[AVAILABILITY_DATE]|Date()| |
|[FIRST_NAME]|Varchar2(50)| |
|[MIDDLE_NAME]|Varchar2(50)| |
|[LAST_NAME]|Varchar2(50)| |
|[SALUTATION]|Varchar2(30)| |
|[RANK]|Varchar2(30)| |
|[BIRTH_DATE]|Date()| |
|[BIRTHPLACE]|Varchar2(50)| |
|[GENDER]|Varchar2(30)| |
|[LANGUAGE_CODE]|Varchar2(30)| |
|[ETHNIC]|Varchar2(30)| |
|[CHALLENGED]|Varchar2(30)| |
|[VETERAN_STATUS]|Varchar2(30)| |
|[ADDRESS_LINE_1]|Varchar2(50)| |
|[ADDRESS_LINE_2]|Varchar2(50)| |
|[LOCALITY]|Varchar2(50)| |
|[ZIP_POSTAL]|Varchar2(16)| |
|[MAIL_ADDRESS_LINE_1]|Varchar2(50)| |
|[MAIL_ADDRESS_LINE_2]|Varchar2(50)| |
|[MAIL_LOCALITY]|Varchar2(50)| |
|[STATE_PROVINCE_CODE_MAIL]|Varchar2(16)| |
|[MAIL_ZIP_POSTAL]|Varchar2(16)| |
|[PHONE_UNLISTED]|Varchar2(4)| |
|[PHONE_NUMBER]|Varchar2(20)| |
|[PHONE_EXTENSION]|Varchar2(16)| |
|[ALT_PHONE_NUMBER]|Varchar2(20)| |
|[ALT_PHONE_EXTENSION]|Varchar2(16)| |
|[FAX_NUMBER]|Varchar2(20)| |
|[CELLULAR_NUMBER]|Varchar2(20)| |
|[EMAIL_ADDRESS]|Varchar2(50)| |
|[MARITAL_STATUS]|Varchar2(30)| |
|[MARRIED_DATE]|Date()| |
|[NUMBER_DEPENDENTS]|Number(5)| |
|[TRANSPORTATION]|Varchar2(30)| |
|[YEARS_EDUCATION]|Number(5)| |
|[BONDED_STATUS]|Varchar2(30)| |
|[CITIZEN_STATUS]|Varchar2(30)| |
|[FOREIGN_CODE]|Varchar2(16)| |
|[DRIVERS_LICENSE]|Varchar2(30)| |
|[PA_NUMBER]|Number(10)| |
|[PA_EFFECTIVE_DATE]|Date()| |
|[GOVT_CODE_ORIGIN]|Varchar2(30)| |
----
!!Tab 1
;[ID|ID]:This field uniquely identifies the candidate record within the data base.
;[Candidate|CANDIDATE_CODE]:This field provides a code to identify the candidate.
;[Submitted On|DATE_SUBMITTED]:This field displays the date the candidate submitted their application.
;[Candidate Status|CANDIDATE_STATUS]:This field will indicate the status of candidate within the recruiting process.
;[Recruiters|RECRUITER_CODE]:This field will display the recruiter used for this candidate.
;[Employee|PERSON_CODE_EMPLOYEE]:
;[Referral|PERSON_CODE_REFERRAL]:
;[Country Name|COUNTRY_CODE]:The country where the candidate resides is displayed in this field.
;[State/Province|STATE_PROVINCE_CODE]:The state/province where the candidate resides is displayed in this field.
;[Tax Jurisdiction|GEO_CODE]:The tax jurisdiction for the candidate is displayed in this field.
;[School|SCHOOL_DISTRICT_CODE]:The school district for the candidate is displayed in this field.
;[Candidate Type|CANDIDATE_TYPE]:This field will indicate whether the candidate is an internal or external applicant.
;[Candidate Category|CANDIDATE_CATEGORY]:This field allows you to group the candidate into a specific group.
;[Current Employer|CURRENT_EMPLOYER]:This field will display the name of the candidate’s current employer.
;[Current Title|CURRENT_TITLE]:This field will display the candidate’s title at their current employment.
;[Candidate Source|CANDIDATE_SOURCE]:This field will indicate the source where the candidate was drawn from.
;[Candidate Password|CANDIDATE_PASSWORD]:
;[Password Changed On|PASSWORD_CHANGED_DATE]:This field displays the date the password was changed.
;[Password Changed By|PASSWORD_CHANGED_BY]:This field indicates who changed the password.
;[External Candidate ID|EXTERNAL_CANDIDATE_ID]:If an external ID number has been assigned to this candidate, that number will be displayed in this field.
\\
----
!!Tab 2
;[SSN Verified|GOVT_CODE_VERIFIED]:If this toggle is ON, the government code has been verified as a legitimate code for that individual.
;[Start Date|APPLICATION_START_DATE]:This field will indicate the first date the application is open.
;[End Date|APPLICATION_END_DATE]:This field will indicate the last date the application is open.
;[Available As Of|AVAILABILITY_DATE]:This field will indicate the date the candidate is available to begin a new job.
;[First Name|FIRST_NAME]:This field provides the first name of the candidate.
;[Middle Name|MIDDLE_NAME]:This field provides the middle name of the candidate.
;[Last Name|LAST_NAME]:This field provides the last name of the candidate.
;[Salutation|SALUTATION]:This field identifies the title of the candidate.
;[Rank|RANK]:This field shows any name extension (i.e. Jr., Sr., III etc.) the candidate may have.
;[Date of Birth|BIRTH_DATE]:This field will display the birth date of the candidate.
;[Birthplace|BIRTHPLACE]:This field displays where the candidate was born.
;[Gender|GENDER]:This field will display the gender of the candidate.
;[Language|LANGUAGE_CODE]:This field will indicate the candidate’s main language of communication.
;[Ethnic|ETHNIC]:This field allows you to record the candidate’s ethnic background.
;[Challenged|CHALLENGED]:If the candidate is physically challenged, this field allows you to indicate as such.
;[Veteran Status|VETERAN_STATUS]:If the candidate is a veteran, you may indicate as such in this field.
;[Address 1|ADDRESS_LINE_1]:This field provides initial information for the candidate’s address, such as street number.
;[Address 2|ADDRESS_LINE_2]:This field provides additional address information such as the PO box number or suite number.
;[City/Town|LOCALITY]:This field refers to the city, district or township for the candidate’s address.
;[Zip Code|ZIP_POSTAL]:This field holds the zip or postal code for the address.
\\
----
!!Tab 3
;[Mailing Address 1|MAIL_ADDRESS_LINE_1]:This field provides initial information for the candidate’s mailing address, such as street number.
;[Mailing Address 2|MAIL_ADDRESS_LINE_2]:This field provides additional mailing address information such as the PO box number or suite number.
;[Mailing City/Town|MAIL_LOCALITY]:This field refers to the city, district or township for the candidate’s mailing address.
;[Mailing State|MAIL_STATE_PROVINCE_CODE]:This field refers to the state or province for the candidate's mailing address.
;[Mailing Zip Code|MAIL_ZIP_POSTAL]:This field holds the zip or postal code for the mailing address.
;[Phone Unlisted|PHONE_UNLISTED]:This field displays any unlisted phone number the candidate supplies.
;[Phone #|PHONE_NUMBER]:This field displays the candidate's phone number.
;[Phone Ext.|PHONE_EXTENSION]:This field displays the extension (if any) for the candidate.
;[Alt. Phone #|ALT_PHONE_NUMBER]:This field displays an alternate phone number for the candidate.
;[Alt. Phone Ext.|ALT_PHONE_EXTENSION]:This is the extension (if any) for the alternate phone number.
;[Cellular #|CELLULAR_NUMBER]:This field holds the candidate’s mobile phone number.
;[E-mail|EMAIL_ADDRESS(Field)]:This field shows the email address or domain name for the candidate.
;[Marital Status|MARITAL_STATUS]:This field will indicate the marital status of the candidate.
;[Date of Marriage|MARRIED_DATE]:The date the candidate was married is displayed in this field.
;[Number of Dependents|NUMBER_DEPENDENTS]:This field will display the number of the dependents the candidate has.
;[Transportation|TRANSPORTATION]:This field shows the candidate’s main means of transportation.
;[Years of Education|YEARS_EDUCATION]:This field will indicate the years of formal education the candidate has had.
;[Bonded Status|BONDED_STATUS]:This field will indicate if the candidate is bonded.
;[Citizen Status|CITIZEN_STATUS]:This field will display the citizen status of the candidate.
\\
----
!!Tab 4
;[Foreign ID|FOREIGN_CODE]:This field shows any foreign registration codes for the candidate.
;[Driver's License|DRIVERS_LICENSE]:If the candidate has a driver’s license, this field will display the license number.
;[PA #|PA_NUMBER]:This field identifies any personnel action associated with this candidate.
;[PA In Effect As Of|PA_EFFECTIVE_DATE]:This field displays the date that the personnel action will become effective.
;[Govt Code Origin|GOVT_CODE_ORIGIN]:This field displays the candidate’s country of origin.
At line 77 removed 2 lines
[{If var='loginstatus' contains 'authenticated'
At line 80 changed 4 lines
![Discussion|Edit:Internal.IVRCA]
[{InsertPage page='Internal.IVRCA' default='Click to create a new discussion page'}]
}]
![Notes|Edit:Internal.IVRCA]
[{InsertPage page='Internal.IVRCA' default='Click to create a new notes page'}]
This page (revision-14) was last changed on 26-Nov-2021 10:22 by kparrottTop