!!!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], [P2K_RE_RECRUITING_COSTS], [P2K_RE_RECRUITING_LOGS], [P2K_RE_EDUCATIONS], [P2K_RE_RESUMES], [P2K_RE_ASSESSMENT_EVENTS], [P2K_RE_ASSESSMENTS], 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|PERSON_CODE]: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 will automatically 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_SOURCE]. ;[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 Contact|HOW_TO_CONTACT_TEXT]:This field allows you to define how to contact the candidate. How_To_Contact_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: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_TRANSPORTATION]. ;[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_STATUS]: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.|AVAILABILITY_DATE]: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|RECRUITER_CODE]: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|WEB_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|POSTING_CODE]:This field indicates the [posting|JOB POSTINGS] the candidate has applied for. [Posting|JOB POSTINGS] 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|JOB POSTINGS]. Posting_Title will default in once the [Posting|JOB POSTINGS] field has been filled. Users may __NOT__ edit this information in this screen; it can only be changed through the [IRPO] screen. ;[Application|APPLICATION_CODE]: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|JOB POSTINGS]. 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|ENTITY_CODE]:This field identifies the entity associated to this [posting|JOB POSTINGS]. Entity from [IDEN] ([P2K_CM_ENTITIES]) is a mandatory field you must fill with a selection from the LOV (F9). ;Stage Description:This field indicates the current stage in the recruiting process for this [posting|JOB POSTINGS]. Stage_Desc from [IRJP] ([P2K_RE_JOB_PROFILES]) is a mandatory field you must fill with a selection from the LOV (F9). ;[Offered|OFFERED_DATE]:If the candidate is selected for this [posting|JOB POSTINGS], 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|JOB POSTINGS]. 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: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|QUALIFICATION_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_CODE]:This field will indicate if the qualification belongs to a subtype of qualification. ;[Status|QUALIFICATION_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|QUALIFICATION_CATEGORY]:This field allows you to further classify the qualification into specific categories. Qualification_Category 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_CONFIRMED_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. ;[Year Last Used|YEAR_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. ---- !!Maintain Candidate Profiles (IRCA) - Costs This screen allows you to record any costs associated to the recruitment process in regards to this candidate. The definition data for the Costs screen is stored in the [P2K_RE_RECRUITING_COSTS] table. \\ ;[Cost Date|COST_DATE]:This field will show the date the recruiting cost was incurred. Cost_Date is an optional field you may fill with a selection from the calendar (F9). ;[Cost Item Category|COST_ITEM_CATEGORY]:This field allows you to group the cost into a specific category. Cost_Item_Category is an optional field you may fill with a selection from the user-defined lexicon [X_COST_ITEM_CATEGORY]. ;[Cost Amount|COST_AMOUNT]:This field displays the actual amount of the cost incurred. Cost_Amount is an optional 18-character numeric field you may fill manually. ;[Description|DESCRIPTION]:This field holds a short description of the cost incurred. Description is an optional 50-character alphanumeric field you may fill manually. ;[Employer %|EMPLOYER_PERCENT]:This field will indicate the percentage of the cost that will be covered by the employer. Employer_Percent is an optional 5-character numeric field you may enter manually. ;[Cost Reference|COST_REFERENCE]:This field allows you to record a short reference for this cost, for example, an invoice number. Cost_Reference is an optional 50-character alphanumeric field you may manually enter. ;[Payment Method|PAYMENT_METHOD]:This field will show the manner in which this item was paid for. Payment_Method is an optional field you must fill with a selection from the fixed lexicon [X_PAYMENT_METHOD]. ;[Payment Status|PAYMENT_STATUS]:This field will show the status of the payment for this cost item. Payment_Status is an optional field you must fill with a selection from the fixed lexicon [X_PAYMENT_STATUS]. ;[Posting|POSTING_CODE]:If this cost is associated with a specific posting, that posting may be identified in this field. Posting from [IRPO] ([P2K_RE_POSTINGS]) is an optional field you must fill through the LOV (F9). ;[Recruiter|RECRUITER_CODE]:If the cost is related to a specific recruiter, that recruiter may be identified in this field. Recruiters from [IRRE] ([P2K_RE_RECRUITERS]) is an optional field you must fill through the LOV (F9). ---- !!Maintain Candidate Profiles (IRCA) - Recruiting Log This tab allows you to track the recruiting activities associated with this candidate. The definition data for the Recruiting Log tab is stored in the [P2K_RE_RECRUITING_LOGS] table. \\ ;[Date/Time|RECRUITING_LOG_TIMESTAMP]:This field displays the day and time of the recruiting log. Recruiting_Log_Timestamp is a mandatory field you may fill either manually or using the calendar (F9). ;[Type|RECRUITING_LOG_TYPE]:This field identifies the nature of the recruitment log. Recruiting_Log_Type is an optional field you may fill with a selection from the fixed lexicon [X_RECRUITING_LOG_TYPE]. ;[Category|RECRUITING_LOG_CATEGORY]:This field allows you to further classify the recruiting log into specific groups. Recruiting_Log_Category is an optional field you may fill with a selection from the user-defined lexicon [X_RECRUITING_LOG_CATEGORY]. ;[Posting|POSTING_CODE]:This field displays the [posting|JOB POSTINGS] associated with this recruiting log. [Posting|JOB POSTINGS] from [IRPO] ([P2K_RE_POSTINGS]) is an optional field you must fill through the LOV (F9). ;[Recruiter|RECRUITER_CODE]:This field displays the recruiter associated with this recruiting log. Recruiter from [IRRE] ([P2K_RE_RECRUITERS]) is an optional field you must fill through the LOV (F9). ;[Entered For|ENTERED_FOR]:This field allows you to indicate for whom or what (position, job profile, candidate) this log is entered. Entered_For is an optional 50-character alphanumeric field you may enter manually. ;[Description|DESCRIPTION]:This field allows you to provide a short description of the recruiting log. Description is an optional 50-character alphanumeric field you may enter manually. ;[Log Text|RECRUITING_LOG_TEXT]:This field provides additional information about the recruiting log. Log_Text is an optional 4000-character alphanumeric field you may enter manually. ---- !!Maintain Candidate Profiles (IRCA) - Education This screen allows you to make a record of the candidate’s formal education. The definition data for the Education tab is stored in the [P2K_RE_EDUCATIONS] table. \\ ;[Education Type|EDUCATION_TYPE]:This field allows you to classify the education being recorded into specific types. Education_Type is an optional field you may fill with a selection from the fixed lexicon [X_EDUCATION_TYPE]. ;[Description|DESCRIPTION]:This field allows you to provide a short description of the education being recorded. Description is an optional 50-character alphanumeric field you may fill manually. ;[Education Status|EDUCATION_STATUS]:This field displays the status of the education being recorded. Education_Status is an optional field you may fill with a selection from the fixed lexicon [X_EDUCATION_STATUS]. ;[School Name|SCHOOL_NAME]:This field indicates the school associated with the education defined. School_Name is an optional 50-character alphanumeric field you may fill manually. ;[Faculty|SCHOOL_FACULTY]:This field indicates the school faculty associated with the education defined. School_Faculty is an optional 50-character alphanumeric field you may fill manually. ;[City|LOCALITY]:This field displays the location of the school. Locality is an optional 50-character alphanumeric field you may fill manually. ;[State/Prov.|P2K_CM_STATE_PROVINCES]:This field defines the state or province of the school. State_Province from [IDSP] ([P2K_CM_STATE_PROVINCES]) is an optional field you may fill with a selection from the LOV (F9). ;[Start Month|EDUCATION_START_MONTH]:This field indicates the date the course of education was begun. Education_End_Month is an optional date field you may fill through the calendar (F9) provided. ;[End Month|EDUCATION_END_MONTH]:This field indicates the date the course of education was completed. Education_End_Month is an optional date field you may fill through the calendar (F9) provided. ;[Major|MAJOR_AREA_OF_STUDY]:This field will display the major area of study for the education defined, for example, English, Russian Studies, or Accounting. Major_Area_of_Study is an optional field you may fill with a selection from the fixed lexicon [X_MAJOR_AREA_OF_STUDY]. ;[Minor|MINOR_AREA_OF_STUDY]:This field will display the minor area of study for the education defined. Minor_Area_of_Study is an optional 50-character alphanumeric field you may fill manually. ;[Degree|DEGREE]:This field will display the degree attained, if applicable, for this course of education. Degree is an optional field you may fill with a selection from the fixed lexicon [X_DEGREE]. ;[GPA Attained|GPA_ATTAINED]:This field displays the Grade Percent Average (GPA) the candidate achieved for this education. GPA_Attained is an optional 7-character numeric field you may fill manually. ;[GPA Maximum|GPA_MAXIMUM]:This field provides the highest Grade Percent Average (GPA) attainable for this education. GPA_Maximum is an optional 7-character numeric field you may fill manually. ;[Text|EDUCATION_TEXT]:This field allows you to provide additional information about the education for this candidate. Education_Text is an optional 4000-character alphanumeric field you may fill manually. ---- !!Maintain Candidate Profile (IRCA) - References This screen allows you to make a record references and reference contacts the candidate has submitted. \\ ;[Contact Name|CONTACT_NAME]:This field displays the name of the individual providing the reference. Contact_Name is an optional 50-character alphanumeric field you may fill manually. ;[Type|REFERENCE_TYPE]:This field allows you to classify the references into specific types. Reference_Type is an optional field you may fill with a selection from the fixed lexicon [X_REFERENCE_TYPE]. ;[Status|REFERENCE_STATUS]:This field will display the current status of the reference provided. Reference_Status is an optional field you may fill with a selection from the fixed lexicon [X_REFERENCE_STATUS]. ;[Contacted|DATE_CONTACTED]:This field will display the date the individual who gave the reference was contacted. Date_Contacted is an optional date field you may fill using the calendar (F9) provided. ;[Contact Title|CONTACT_TITLE]:This field displays the reference’s title within their company. Contact_Title is an optional 50-character alphanumeric field you may fill manually. ;[Company Name|COMPANY_NAME]:This field displays the company name where the reference is employed. Company_Name is an optional 50-character alphanumeric field you may fill manually. ;[Address 1|ADDRESS_LINE_1]:This field displays the address of the company. Address_Line_1 is an optional 50-character alphanumeric field you may fill manually. ;[Address 2|ADDRESS_LINE_2]:This field provides further address information for the company. Address_Line_2 is an optional 50-character alphanumeric field you may fill manually. ;[City|LOCALITY]:This field displays the city or town for the company’s address. Locality is an optional 50-character alphanumeric field you may fill manually. ;[State/Prov.|P2K_CM_STATE_PROVINCES]:This field displays the state or province description with the applicable country concatenated at the end. State_Province_Code from [IDSP] ([P2K_CM_STATE_PROVINCES]) is an optional field that you may fill from the LOV (F9). ;[Zip Postal|ZIP_POSTAL]:This field holds the zip or postal code for the address. Zip_Postal is an optional 16-character alphanumeric field you may fill manually. ;[Phone #|PHONE_NUMBER]:‘Phone Number’ is the main phone number for the reference. 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 reference. 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 reference. Alt_Phone_Number is an optional 20-character alphanumeric field that may be manually entered. ;[Alt. Phone Ext.|ALT_PHONE_EXTENSION]:This is the extension (if any) for the alternate phone number. Alt_Phone_Extension is an optional 16-character alphanumeric field that may be manually entered. ;[Fax #|FAX_NUMBER]:This field provides a fax number for the candidate's reference. Fax_Number is an optional 20-character alphanumeric field you may fill manually. ;[Language|LANGUAGE_CODE]:This field will indicate the reference’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]. ;[Available to Contact|AVAILABLE_TO_CONTACT]: This is an optional toggle used to indicate if the candidate's referral is available to contact. ;[Text|REFERENCE_TEXT]: This field provides the user the ability to add additional information regarding the reference. Reference_Text is an optional 4000-character alphanumeric field. ---- !!Maintain Candidate Profile (IRCA) - Work History ;[Start Date|ASSIGNMENT_START_DATE]:This field is used to display the start date the candidate began working in their previous assignment. ;[End Date|ASSIGNMENT_END_DATE]: ;[Company Name|COMPANY_NAME]:This field displays the company name where the reference is employed. Company_Name is an optional 50-character alphanumeric field you may fill manually. ;[Status|VERIFIED_STATUS]:This is an optional field used to indicate if the candidate's work history has been verified. Verified_Status is tied to the lexicon [X_VERIFIED_STATUS]. ;[Verified|DATE_VERIFIED]:This is a date field used to indicate what date the candidate's work history was verified. ;[Cont. Name|CONTACT_NAME]:This field displays the name of the individual providing the reference. Contact_Name is an optional 50-character alphanumeric field you may fill manually. ;[Cont. Title|CONTACT_TITLE]:This field displays the reference’s title within their company. Contact_Title is an optional 50-character alphanumeric field you may fill manually. ;[Address 1|ADDRESS_LINE_1]:This field displays the address of the company. Address_Line_1 is an optional 50-character alphanumeric field you may fill manually. ;[Address 2|ADDRESS_LINE_2]:This field provides further address information for the company. Address_Line_2 is an optional 50-character alphanumeric field you may fill manually. ;[City|LOCALITY]:This field displays the city or town for the company’s address. Locality is an optional 50-character alphanumeric field you may fill manually. ;[State|P2K_CM_STATE_PROVINCES]:This field displays the state or province description with the applicable country concatenated at the end. State_Province_Code from IDSP (P2K_CM_STATE_PROVINCES) is an optional field that you may fill from the LOV (F9). ;[Postal Code|ZIP_POSTAL]:This field holds the zip or postal code for the address. Zip_Postal is an optional 16-character alphanumeric field you may fill manually. ;[Phone #|PHONE_NUMBER]:Phone Number is the main phone number for the reference. Phone_Number is an optional 20-character alphanumeric field that may be manually entered. ;[Extn. |PHONE_EXTENSION]:This field displays the extension (if any) for the reference. 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 reference. Alt_Phone_Number is an optional 20-character alphanumeric field that may be manually entered. ;[Alt. Extn.|ALT_PHONE_EXTENSION]:This is the extension (if any) for the alternate phone number. Alt_Phone_Extension is an optional 16-character alphanumeric field that may be manually entered. ;[Fax #|FAX_NUMBER]:This field provides a fax number for the candidate's reference. Fax_Number is an optional 20-character alphanumeric field you may fill manually. ;[E-Mail|EMAIL_ADDRESS]:This field shows the email address or domain name for the candidate's reference. Email_Address is a 50-character optional alphanumeric field that may be manually entered. ;[Lang.Code|LANGUAGE_CODE]:This field will indicate the reference’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]. ;[Industry|INDUSTRY_CODE]:This field holds the six-digit industry codes for NAICS (North American Industry Code Standard) for the company. Industry from [IDIN] ([P2K_CM_INDUSTRIES]) is an optional field you may fill with a selection from the LOV (F9). ;[Company Size|COMPANY_SIZE]:This field will indicate the number of people working for the company. Company_Size is an optional field you may fill with a selection from the fixed lexicon [X_COMPANY_SIZE]. ;[Emp. Type|EMPLOYMENT_TYPE]:This field will identify the specific type of employment the candidate had with the company. Employment_Type is an optional field you may fill with a selection from the fixed lexicon [X_EMPLOYMENT_TYPE]. ;[Group Type|GROUP_TYPE]:This field allows you to further define the type of employment the candidate had with the company Group_Type is an optional field you may fill with a selection from the fixed lexicon [X_GROUP_TYPE]. ;[Job Category|JOB_CATEGORY]:This field allows you to define the type of job associated with this employment. Job_Category is an optional field you may fill with a selection from the fixed lexicon [X_JOB_CATEGORY]. ;[Job Title|ASSIGNMENT_TITLE]:This field shows the title the candidate held in the company defined. Assignment_Title is an optional 50-character alphanumeric field you may fill manually. ;[Resp. Level|RESPONSIBILITY_LEVEL]:This field indicates the level of responsibility the candidate had at the company. Responsibility_Level is an optional field you may fill with a selection from the fixed lexicon [X_RESPONSIBILITY_LEVEL]. ;[Hours/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/Week|HOURS_PER_WEEK]:This field shows the average weekly hours associated with this assignment. Hours_Per_Week is an optional 9-character numeric field you may enter manually. ;[Wage Rate|WAGE_RATE]:This field will show the wage rate for this assignment. Wage_Rate is an optional 18-character numeric field you may fill manually. ;[Rate Basis|RATE_BASIS]:This field shows the rate basis that the wage is expressed in. Rate_Basis is an optional field you may fill with a selection from the fixed lexicon [X_RATE_BASIS]. ;[Rsn Leaving|REASON_FOR_LEAVING]:This field will show the reason the candidate left the assignment. Reason_for_Leaving is an optional field you may fill with a selection from the fixed lexicon [X_REASON_FOR_LEAVING]. ;[Text|WORK_HISTORY_TEXT]:This field allows you to provide additional information about the past employment. Work_History_Text is an optional 4000-character alphanumeric field you may enter manually. ---- !!Maintain Candidate Profiles (IRCA) - Resumes This screen allows you to make a record of the candidate’s resume. The definition data for the Resume tab is stored in the [P2K_RE_RESUMES] table. \\ ;[Received|DATE_RECEIVED]:This field displays the date the resume was received from the candidate. Date_Received is a mandatory date field you must fill with the calendar (F9) provided. ;[Source|RESUME_SOURCE]:This field will indicate the source of the resume. Resume_Source is an optional field you may fill with a selection from the fixed lexicon [X_RESUME_SOURCE]. ;[File Name (on server FS)|BINARY_FILE]:This field is used to locate the file on the server to upload the file. ;[Format|RESUME_FORMAT]:This field identifies the format in which the resume was received. Resume_Format is an optional field the use may fill with a selection from the fixed lexicon [X_RESUME_FORMAT]. ;[Location / Comments|RESUME_LOCATION]: This is an optional 2000-character alphanumeric field which may be used to add additional comments on the location of the resume. ;[Last Revised|RESUME_LAST_REVISED]:This field will display the date the resume was last updated. Resume_Last_Revised is an optional date field you may fill using the calendar (F9) provided. ---- !!Maintain Candidate Profiles (IRCA) - Assessments This screen allows you to create a log of the candidate’s [assessment events|ASSESSMENT EVENTS]. Any [assessment events|ASSESSMENT EVENTS] that the candidate is scheduled for or has taken will be recorded here. The definition data for the [Assessments|ASSESSMENTS] tab is stored in the [P2K_RE_ASSESSMENTS] and [P2K_RE_ASSESSMENT_EVENTS] tables. \\ ;[Date/Time|ASSESSMENT_DATE_TIME]:This field indicates the date/time of the [assessment|ASSESSMENTS]. Assessment_Date_Time is a mandatory field you may fill either manually or with the calendar (F9) provided. ;[Assessments|ASSESSMENT_CODE]:This field defines the exact [assessment|ASSESSMENTS] the candidate will be taking. Assessment from [IRAS] ([P2K_RE_ASSESSMENTS]) is a mandatory field you must fill with a selection from the LOV (F9). ;[Description|DESCRIPTION]:This field provides a short description of the [assessment|ASSESSMENTS]. This field will automatically default in from IRAS once the ‘Assessment’ field has been filled. You __CANNOT__ edit the information in this screen. ;[Status|ASSESSMENT_EVENT_STATUS]:This field will display the current status of the [assessment event|ASSESSMENT EVENTS]. Assessment_Event_Status is an optional field you may fill with a selection from the fixed lexicon [X_ASSESSMENT_EVENT_STATUS]. ;[Location|P2K_CM_LOCATIONS]:This field will indicate where the [assessment|ASSESSMENTS]is to take place. Location from [IDLN] ([P2K_CM_LOCATIONS]) is an optional field you may fill with a selection from the LOV (F9). ;Conducted By:This field will display the name of the individual conducting the [assessment|ASSESSMENTS]. Conducted_By from [IEAS] ([P2K_HR_ASSIGNMENTS]) is an optional field you may fill with a selection from the LOV (F9). ;Contact: If there is a contact person for this [assessment event|ASSESSMENT EVENTS], that individual may be indicated here. Contact from [IECT] ([P2K_HR_CONTACTS]) is an optional field you may fill with a selection from the LOV (F9). ;[Rating|ASSESSMENT_RATING]:This field displays the rating the candidate received for this [assessment|ASSESSMENTS]. Assessment_Rating is an optional field you may fill with a selection from the fixed lexicon [X_ASSESSMENT_RATING]. ;[Points|ASSESSMENT_POINTS]:This field allows you to record the points the candidate obtained in this [assessment|ASSESSMENTS]. Assessment_Points is an optional 5-character numeric field you may fill manually. ;[Type|ASSESSMENT_TYPE]:This field groups this the [assessment|ASSESSMENTS] into a specific type. This field will automatically default in from [IRAS] once the ‘Assessment’ field has been filled. Users CANNOT edit the information in this screen. ;[Category|ASSESSMENT_CATEGORY]:This field further classifies the [assessment|ASSESSMENTS] into specific groups. This field will automatically default in from IRAS once the ‘Assessment’ field has been filled. Users CANNOT edit the information in this screen. ;[Desired Pts|DESIRED_POINTS]:This field will display the desired points the candidate must obtain for this [assessment|ASSESSMENTS]. This field will automatically default in from [IRAS] once the ‘Assessment’ field has been filled. Users CANNOT edit the information in this screen. ;[Essential Pts|ESSENTIAL_POINTS]:This field will display the points the candidate must obtain to pass this [assessment|ASSESSMENTS]. This field will automatically default in from [IRAS] once the ‘Assessment’ field has been filled. Users CANNOT edit the information in this screen. ---- !!Maintain Candidate Profiles (IRCA) - Self Service Access This tab is used to grant the Candidate access to Self Service. ;[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. ;[First Name|FIRST_NAME]:This field is used to provide the legal first name of the individual. If this is used when hiring an individual the field MUST be completed. First_Name is a 50-character alphanumeric field. ;[Last Name|LAST_NAME]:This field is used to provide the legal surname name of the individual. If this is used when hiring an individual the field MUST be completed. Last_Name is a 50-character alphanumeric field. ;[Email|EMAIL_ADDRESS]:This field displays the candidate’s email address. ;[Password Change By|PASSWORD_CHANGE_BY]:This filed will indicate the user who last changed the candidate’s password. ;[Password Change On|PASSWORD_CHANGE_DATE]:This field will display the date the password was last changed. ;[Access Key|ACCESSOR_KEY]:This is used as a login method, instead of providing a user name users may provide an access key. When the site preference 'SS LOGIN TYPE' is set to ‘ACCESSOR KEY’, the Access Key login page (Access Key/PIN) will be used. This field is a 30-character field and is not case sensitive. ;[Access Start Date|ACCESS_START_DATE]:This field indicates the first day the candidate may access Self Service. ;[Access End Date|ACCESS_END_DATE]:This field indicates the last day that the candidate may access Self Service. ;[Force Password Change On Next Login|FORCE_PASSWORD_CHANGE]:If this toggle is on, the candidate will need to change their password the next time they log into Self Service. ;[Last Good Access|LAST_GOOD_ACCESS]:This field indicates the last date the candidate successfully logged into the system. ;[Logins to Date|LOGINS_TO_DATE]:This field shows the number of successful logins the candidate has made. ;[Set/Reset Password|ACT_RESET_PASSWORD]:Clicking this button will set or reset the candidate’s password. ;[Reactivate|ACT_SET_ACTIVE]: This button is used to re-activate a user's access to the application if their previous access was locked out or is in a pending state. ;[Access Status|ACCESS_STATUS]:This field displays the candidate’s access status. Access_Status is associated to the lexicon [X_ACCESS_STATUS] ;[Failed Attempts|FAILED_ATTEMPTS]:This field displays the number of unsuccessful logins the candidates have made. ;[Password Set|DRV_PASSWORD_SET]:If this toggle is on, the candidate’s password is set.