!!!MAINTAIN CANDIDATE PROFILES Candidate profiles are created and maintained in the Maintain Candidate Profiles (IRCA) form. \\ \\ The definition data for the Maintain Candidate Profile screen is stored in the [P2K_RE_CANDIDATES], [P2K_RE_APPLICATIONS], and [P2K_RE_QUALIFICATIONS] tables. \\ ---- !!Maintain Candidate Profiles (IRCA) - Candidate ;[Candidate|CANDIDATE_CODE]:This field provides a code to identify the candidate. Candidate_Code is a mandatory 50-character alphanumeric field that you must manually enter. __This field will automatically fill in if candidate sequencing has been defined in the Define Code Sequencing (IMCS) table.__ ;[Submitted On|DATE_SUBMITTED]:This field displays the date the candidate submitted their application. Date_Submitted is a mandatory field you may fill with the calendar provided (F9). ;[Salutation|SALUTATION]:This field identifies the title of the candidate. Salutation is an optional field you must fill with a selection from the fixed lexicon [X_Salutation]. ;[First Name|FIRST_NAME]:This field provides the first name of the candidate. First_Name is an optional 50-character alphanumeric field you may enter manually. If this candidate is to be hired, the field __MUST__ be completed. ;[Middle Name|MIDDLE_NAME]:This field provides the middle name of the candidate. Middle_Name is an optional 50-character alphanumeric field you may enter manually. ;[Last Name|LAST_NAME]:This field provides the last name of the candidate. Last_Name is an optional 50-character alphanumeric field you may enter manually. If this candidate is to be hired, the field MUST be completed. ;[Person Code|P2K_HR_IDENTITIES]:This field identifies an internal employee as a candidate. Once this field has been filled, the previous fields (Salutation, First Name, etc.) and the Address and Phone fields willautomatically fill. Person_Code from [IEID] ([P2K_HR_IDENTITIES]) is an optional field you must fill through the LOV (F9). ;[Status|CANDIDATE_STATUS]:This field will indicate the status of candidate within the recruiting process. Candidate_Status is an optional field you must fill with a selection from you define lexicon [X_Candidate_Status]. ;[Source|CANDIDATE_SOURCE]:This field will indicate the source where the candidate was drawn from. Candidate_Source is an optional field you must fill with a selection from you define lexicon [X_CANDIDATE_SOUCE]. ;[Type|CANDIDATE_TYPE]:This field will indicate whether the candidate is an internal or external applicant. Candidate_Type is optional field you may fill with a selection from the fixed lexicon [X_CANDIDATE_TYPE]. ;[Category|CANDIDATE_CATEGORY]:This field allows you to group the candidate into a specific group. Candidate_Category is an optional field you may fill with a selection from the user-defined lexicon [X_CANDIDATE_CATEGORY]. __The information for the ‘Address’ and ‘Phone’ sections will automatically default in from IEHR if the candidate is already an employee.__ ;[Address 1|ADDRESS_LINE_1]:This field provides initial information for the candidate’s address, such as street number. Address_Line_1 is an optional 50-character alphanumeric field that may be manually entered. ;[Address 2|ADDRESS_LINE_2]:This field provides additional address information such as the PO box number or suite number. Address_Line_2 is a 50-character alphanumeric optional field that may be manually entered. ;[City|LOCALITY]:This field refers to the city, district or township for the candidate’s address. Locality is an optional 50-character alphanumeric field that may be manually entered. ;[State/Province|P2K_CM_STATE_PROVINCE]:This field displays the state or province description with the applicable country concatenated at the end. State_Province_Code from [P2K_CM_STATE_PROVINCES] is a mandatory field that you must fill from the LOV (F9). If this candidate is to be hired, the field __MUST__ be completed. ;[Zip/Postal|ZIP_POSTAL]:This field holds the zip or postal code for the address. Zip_Postal is an optional 16-character alphanumeric field that may be manually entered. __When entering phone numbers, an entry such as 3144660000 will automatically be formatted to be displayed as (314) 466-0000.__ ;[Phone #|PHONE_NUMBER]:‘Phone Number’ is the main phone number for the candidate. Phone_Number is an optional 20-character alphanumeric field that may be manually entered. ;[Phone Extn|PHONE_EXTENSION]:This field displays the extension (if any) for the candidate. Phone_Extension is an optional 16-character alphanumeric field that may be manually entered. ;[Alt Phone #|ALT+PHONE_NUMBER]:This field displays an alternate phone number for the candidate. Alt_Phone_Number is an optional 20-character alphanumeric field that may be manually entered. ;[Email Address|EMAIL_ADDRESS]:This field shows the email address or domain name for the candidate. Email_Address is a 50-character optional alphanumeric field that may be manually entered. ;[Mobile|CELLULAR_NUMBER]:This field holds the candidate’s mobile phone number. Cellular_Number is an optional 20-character alphanumeric field that may be manually entered. ;[Fax Number|FAX_NUMBER]:This field holds the fax number for the candidate. Fax_Number is an optional 20-character alphanumeric field that may be manually entered. ;[Details|CANDIDATE_TEXT]:This field allows you to provide any additional information about the candidate. Candidate_Text is an optional 4000-character alphanumeric field you may fill manually. ;[Objectives|OBJECTIVES_TEXT]:This field allows you to record the candidate’s career objectives. Objectives_Text is an optional 4000-character alphanumeric field you may fill manually. ;[How to Connect|HOW_TO_CONNECT_TEXT]:This field allows you to define how to connect with the candidate. How_To_Connect_Text is an optional 4000-character alphanumeric field you may fill manually. ---- !!Maintain Candidate Profiles (IRCA) - Details !Background ;[Country of Origin|GOVT_CODE_ORIGIN]:This field displays the candidate’s country of origin. Govt_Code_Origin is an optional field you may fill with a selection from the fixed lexicon [X_GOVT_CODE_ORIGIN]. ;[Gov't Code|GOVERNMENT_CODE]:This field displays the contact's government identification number. Government_Code is an optional 16-character alphanumeric field you may enter manually. If this candidate is to be hired, the field __MUST__ be completed. ''i.e. U.S.A.: Social Security Number (SSN) Canada: Social Insurance Number (SIN)'' ;[Gov't Code Verified|GOVT_CODE_VERIFIED]:If this toggle is ON, the government code has been verified as a legitimate code for that individual. Govt_Code_Verified is an optional toggle field. ;[Gender|GENDER]:This field will display the gender of the candidate. Gender is an optional field you may fill with a selection from the fixed lexicon [X_GENDER]. If this candidate is to be hired, the field __MUST__ be completed. ;[Date of Birth|BIRTH_DATE]:This field will display the birth date of the candidate. Birth_Date is an optional field you may select using the calendar (F9). If this candidate is to be hired, the field __MUST__ be completed. ;[Age|AGE]:This field displays the age of the candidate. Age will automatically fill once the Birth Date field has been completed. ;[Birthplace|BIRTHPLACE]:This field displays where the candidate was born. Birthplace is an optional 50-character alphanumeric field you may enter manually. ;[Foreign Code|FOREIGN_CODE]:This field shows any foreign registration codes for an employee. Foreign_Code is an optional 16-character alphanumeric field you may enter manually. ;[Transportation|TRANSPORTATION]:This field shows the candidate’s main means of transportation. Transportation is an optional field you may fill with a selection from the fixed lexicon [X_TRANSPORATION]. ;[Drivers License|DRIVERS_LICENSE]:If the candidate has a driver’s license, this field will display the license number. Drivers_License is an optional 16-character alphanumeric field you may fill manually. !Demographics ;[Yrs Education|YEARS_EDUCATION]:This field will indicate the years of formal education the candidate has had. Years_Education is an optional 5-character numeric field you may fill manually. ;[Marital Status|MARITAL_STATUS]:This field will indicate the marital status of the candidate Marital_Status is an optional field you may fill with a selection from the fixed lexicon [X_MARITAL_STATUS]. ;[Dependents|NUMBER_DEPENDENTS]:This field will display the number of the dependents the candidate has. Number_Dependents is an optional 5-character numeric field you may enter manually. ;[Language|LANGUAGE_CODE]:This field will indicate the candidate’s main language of communication. English will default. Language_Code is an optional field you may fill with a selection from the fixed lexicon [X_LANGUAGE_CODE]. If this candidate is to be hired, the field MUST be completed. ;[Ethnic|ETHNIC]:This field allows you to record the candidate’s ethnic background. Ethnic is an optional field you may fill with a selection from the fixed lexicon [X_ETHNIC]. If this candidate is to be hired, the field __MUST__ be completed. ;[Citizen Status|CITIZEN_STATUS]:This field will display the citizen status of the candidate. Citizen_Status is an optional field you may fill with a selection from the fixed lexicon [X_CITIZEN_STATUS]. ;[Bonded|BONDED]:This field will indicate if the candidate is bonded. Bonded is an optional field you may fill with a selection from the fixed lexicon [X_BONDED]. ;[Challenged|CHALLENGED]:If the candidate is physically challenged, this field allows you to indicate as such. Challenged is an optional field you may fill with a selection from the fixed lexicon [X_CHALLENGED]. ;[Veteran Status|VETERAN_STATUS]:If the candidate is a veteran, you may indicate as such in this field. Veteran_Status is an optional field you may fill with a selection from the fixed lexicon [X_VETERAN_STATUS]. !Employer If the external candidate is currently employed, the information about the employer may be recorded in this section. ;[Employer|CURRENT_EMPLOYER]:This field will display the name of the candidate’s current employer. Current_Employer is an optional 50-character alphanumeric field you may fill manually. ;[Title|CURRENT_TITLE]:This field will display the candidate’s title at their current employment. Current_Title is an optional 50-character alphanumeric field the use may enter manually. ;[Appl. START|APPLICATION_START_DATE]:This field will indicate the first date the application is open. Application_Start_Date is an optional field you may fill using the calendar (F9) provided. ;[Appl. End|APPLICATION_END_DATE]:This field will indicate the last date the application is open. Application_End_Date is an optional field you may fill using the calendar (F9) provided. ;[Date Avail.|DATE_AVAILABLE]:This field will indicate the date the candidate is available to begin a new job. Date_Available is an optional field you may fill using the calendar (F9) provided. ;[Recruiter|P2K_RE_RECRUITERS]:This field will display the recruiter used for this candidate. Recruiter from [IRRE] ([P2K_RE_RECRUITER]) is an optional field you may fill through the LOV (F9). ;[Ext. ID|EXTERNAL_CANDIDATE_ID]:If an external ID number has been assigned to this candidate, that number will be displayed in this field. External_Candidate_ID is an optional field you may fill manually. ;[Web Address|WED_ADDRESS]:If there is a web address associated with this candidate, that web address would be displayed here. Web_Address is an optional 200-character alphanumeric field you may fill manually. ---- !!Maintain Candidate Profiles (IRCA) - Applications The definition data for the Applications screen is stored in the [P2K_RE_APPLICATIONS] table. ;[Posting|P2K_RE-POSTINGS]:This field indicates the posting the candidate has applied for. Posting from [IRPO] ([P2K_RE_POSTINGS]) is a mandatory field you must fill with a selection from the LOV (F9). ;[Posting Title|POSTING_TITLE]:This field will display the descriptive title of the posting. Posting_Title will default in once the Posting field has been filled. Users may __NOT__ edit this information in this screen; it can only be changed through the [IRPO] screen. ;[Application|APPLICATION]:This field will be displayed the assigned number for the application. Application will be automatically assigned a number. ;[Application Status|APPLICATION_STATUS]:This field displays the current status of the application. Application_Status is an optional field you may fill with a selection from the fixed lexicon [X_APPLICATION_STATUS]. ;[Application Stage|APPLICATION_STAGE]:This field allows you to define the exact stage in the process for this application. For example: Application_Stage is an optional field you may fill with a selection from the user-defined lexicon [X_APPLICATION_STAGE]. ;[Opened|APPLICATION_OPENED]:This field indicates the date the application was applied to the posting. Application_Opened is a mandatory field you must fill using the calendar (F9) provided. ;[Closed|APPLICATION_CLOSED]:This field indicates the date the application was closed with regards to the posting. Application_Closed is an optional field you must fill using the calendar (F9) provided. ;[Rating|APPLICATION_RATING]:This field displays the rating this application received for the posting. Application_Rating is an optional field you may fill a selection from the fixed lexicon [X_APPLICATION_RATING]. ;[Entity|P2K_CM_ENTITIES]:This field identifies the entity associated to this posting.Entity from [IDEN] ([P2K_CM_ENTITIES]) is a mandatory field you must fill with a selection from the LOV (F9). ;[Stage Description|P2K_RE_JOB_PROFILES]:This field indicates the current stage in the recruiting process for this posting. Stage_Desc from [IRJP] ([P2K_RE_JOB_PROFILES]) is a mandatory field you must fill with a selection from the LOV (F9). ;[Application Approved|APPROVED]:If this toggle is ON, the application has been approved. Approved is an optional toggle field. ;[Offered|OFFERED_DATE]:If the candidate is selected for this posting, this field displays the date the job was offered to the applicant. Offered_Date is an optional date field you may fill with the calendar (F9) provided. ;[Response|RESPONSE_DATE]:This field indicates the date the candidate responded to the job offer. Response_Date is an optional date field you may fill with the calendar (F9) provided. ;[Response Indication|RESPONSE_INDICATION]:This field will display the status of the response from the candidate. Response_Indication is an optional field you may fill with a selection from the fixed lexicon [X_RESPONSE_INDICATION]. ;[Rejection Reason|REASON_FOR_REJECTION]:This field provides the reason for the candidate being rejected for the posting. Reason_for_Rejection is an optional field you may fill with a selection from the fixed lexicon [X_REASON_FOR_REJECTION]. ;[Decline Reason|REASON_FOR_DECLINE]:This field provides a reason why the candidate declined the job offer. Reason_for_Decline is an optional field you may fill with a selection from the fixed lexicon [X_REASON_FOR_DECLINE]. ;[Assignment to Replace|P2K_HR_ASSIGNMENTS]:If the candidate to be hired has another assignment in the entity, that assignment is identified in this field. Assignment_To_Replace from [IEAS] ([P2K_HR_ASSIGNMENTS]) is an optional field you must fill through the LOV (F9). __The following fields will usually be automatically filled, however, the values may be changed in this screen.__ ;[Assignment Title|ASSIGNMENT_TITLE]:This field provides the title of the assignment this posting is recruiting for. Assignment_Title is an optional 50-character alphanumeric field you may enter manually. ;[Assignment Start Date|ASSIGNMENT_START_DATE]:If the assignment is date sensitive, the first date of the assignment will be indicated in this field. Assignment_Start_Date is an optional field you may fill either manually or using the icon (F9). ;[Assignment End Date|ASSIGNMENT_END_DATE]:If the assignment is date sensitive, the last date of the assignment will be indicated in this field. Assignment_End_Date is an optional field you may fill either manually or using the calendar (F9). ;[Hours Per Day|HOURS_PER_DAY]:This field shows the average daily hours associated with this assignment. Hours_Per_Day is an optional 9-character numeric field you may enter manually. ;[Hours Per Week|HOURS_PER_WEEK]:This field shows the average daily hours associated with this assignment. Hours_Per_Week is an optional 9-character numeric field you may enter manually. ;[FTE|FTE]:This field will show the full time equivalent associated with this assignment. FTE is an optional 9-character numeric field you may enter manually. ;[Scale/Step|P2K_SA_WAGE_SCALES]:This field displays the wage scale for this assignment. Scale_Step from [ISWS] ([P2K_SA_WAGE_SCALES]) is an optional field you must fill through the LOV (F9). ;[Wage Rate|WAGE_RATE]:This field displays the wage rate for this assignment. Wage_Rate is an optional 18-character numeric field you may fill manually. ;[Basis|RATE_BASIS]:This field displays the basis in which the wage rate is expressed. Rate_Basis is an optional field you may fill with a selection from the fixed lexicon [X_Rate_Basis]. ;[Scale Overridden|SCALE_OVERRIDDEN]:If the toggle is ON, the displayed wage rate has been keyed manually, and is different from the rate on the wage scale table. If the toggle is OFF, either the wage rate has been derived from the wage scale table or wage scale tables are not being used. Scale_Overridden is an optional field. ;[Details|APPLICATION_TEXT]:This field allows you to provide additional information about the application. Application_Text is an optional 4000-character alphanumeric field you must enter manually. ---- !!Maintain Candidate Profiles (IRCA) - Qualifications The definition data for the Qualifications screen is stored in the [P2K_RE_QUALIFICATIONS] table. \\ ;[Type|QUALIFIED_TYPE]:This field allows you to group the qualification into a specific type. Qualified_Type is an optional field you may fill with a selection from the fixed lexicon [X_QUALIFICATION_TYPE]. ;[Subtype|SUBTYPE]:This field will indicate if the qualification belongs to a subtype of qualification. ;[Status|STATUS]:This field will display the status of the qualification. ;[Description|DESCRIPTION]:This field provides a short description of the qualification. Description is an optional 50-character alphanumeric field you may fill manually. ;[Category|CATEGORY]:This field allows you to further classify the qualification into specific categories. Qualification_Catergory is an optional field you may fill with a selection from the user-defined lexicon [X_QUALIFICATION_CATEGORY]. ;[Name|QUALIFICATION_NAME]:This field allows you to name the qualification. Qualification_Name is an optional 50-character alphanumeric field you may fill manually. ;[Reference|QUALIFICATION_REFERENCE]:This field allows you to reference the qualification. For example, if the qualification is a certificate that is issued through a professional organization, that professional organization may be listed here. Qualification_Reference is an optional 50-character alphanumeric field you may fill manually. ;[Start Date|QUALIFICATION_START_DATE]:If the qualification is applied to this candidate for only a specific time period (e.g. a first aid certificate that has to be renewed each year), the first date of the time period is indicated here. Qualification_Start_Date is an optional field you may fill through the calendar (F9) provided. ;[End Date|QUALIFICATION_END_DATE]:If the qualification is applied to this candidate for only a specific time period, the last date of the time period is indicated here. Qualification_End_Date is an optional field you may fill through the calendar (F9) provided. ;[Date Confirmed|DATE_CONFIRMED]:This field shows the date the qualification was confirmed for this candidate. Date_Confirmed is an optional field you may fill through the calendar (F9) provided. ;[Confirmed By|CONFIRMED_BY]:This field indicates who confirmed the qualification for this candidate. Confirmed_By is an optional 50-character alphanumeric field you may fill manually. ;[Confirmed Status|CONFIRMED_STATUS]:This field will indicate the status of the confirmation of the candidate’s qualification. Confirmed_Status is an optional field you may fill with a selection from the fixed lexicon [X_CONFIRMATION_STATUS]. ;[Interest Level|INTEREST_LEVEL]:This field will show the candidate’s interest level in this qualification Interest_Level is an optional field you may fill with a selection from the fixed lexicon [X_INTEREST_LEVEL]. ;[Proficiency|PROFICIENCY]:The level of expertise the candidate has attained in the qualification will be indicated here. Proficiency is an optional field you may fill with selection from the fixed lexicon [X_PROFICIENCY]. ;[Years Experience|YEARS_EXPERIENCE]:This field indicates the number of years of experience the candidate has for this qualification Years_Experience is an optional field you may fill manually. ;[Years Last Used|YEARS_LAST_USED]:This field indicates the number of years since the candidate last used the qualification. Years_Last_Used is an optional field you may fill manually. ;[Text|QUALIFICATION_TEXT]:This field allows you to provide additional information about the qualification for this candidate. Qualification_Text is an optional 4000-character alphanumeric field you may fill manually.