Archive_HR_Applicant (AHR2AP12)

azurecurveProductsHuman Resources (414)SystemArchive_HR_Applicant (AHR2AP12)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AHR2AP12

Product: Human Resources (414)
Series: System

Display Name: Archive_HR_Applicant
Physical Name: AHR2AP12
Technical Name: Archive_HR_Applicant

Group Display Name: HR Multi-Company
Group Technical Name: HR_MultiCmp_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1APPLICANTNUMBER_I SearchApplicant NumberDOLLARCurrency0
2SSN_I SearchISSNSTR15_Social_Security_NumberString15
3LLASTNAME_I SearchLLast NameSTR20String20
4FFIRSTNAME_I SearchFFirst NameSTR15_IString15
5MIDLNAME SearchMiddle NameSTR15String15
6ADDRESS1 SearchAddress 1STR60String60
7ADDRESS2 SearchAddress 2STR60String60
8CITY SearchCitySTR35String35
9STATE SearchStateSTR30_StateString29
10ZIPCODE_I SearchIZip CodeSTR10String10
11COUNTRY SearchCountrySTR60String60
12HOMEPHONE SearchHome PhoneSTR10_PhoneString10
13WORKPHONE SearchWork PhoneSTR10_PhoneString10
14EXT_I SearchExtSTR4_IString4
15ISEQUENCENUMBER_I SearchISequence NumberIINT2Integer2
16APPLYDATE_I SearchApply DateDTDate8
17REQUISITIONNUMBER_I SearchRequisition NumberINT60Long Integer6
18COMPANYCODE_I SearchCompany CodeSTR6_Payroll_CodeString6
19DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString6
20DEPARTMENTCODE_I SearchDepartment CodeSTR6_Payroll_CodeString6
21POSITIONCODE_I SearchPosition CodeSTR6_Payroll_CodeString6
22LOCATNID SearchLocation IDSTR15_Location_IDString15
23STATUS0_I SearchStatus0DDL_Status_HRMInteger0
24REJECTREASON_I SearchReject ReasonDDL_Reject_ReasonInteger0
25DSCRIPTN SearchDescriptionSTR30String30
26RELOCATION_I SearchRelocationGB_IInteger0
27REPLYLETTERSENT_I SearchReply Letter SentCB_ReplyBoolean0
28COLORCODE_I SearchColor CodeVS_Color_CodeInteger0
29COLORSTRING_I SearchColor StringISTR6String6
30REFSOURCEDDL_I SearchRef Source DDLDDL_Ref_SourceInteger0
31REFERENCESOURCE_I SearchReference SourceSTR30_I0String30
32EEOGENDER_I SearchEEO GenderDDL_EEO_GenderInteger0
33EEOETHNICORIGIN_I SearchEEO Ethnic OriginDDL_EEO_Ethnic_OriginInteger0
34EEOAGE_I SearchEEO AgeDDL_EEO_AgeInteger0
35HANDICAPPED SearchHandicappedCB_HandicapBoolean0
36VETERAN SearchVeteranCB_MilitaryBoolean0
37DISABLEDVETERAN SearchDisabled VeteranCB_DisableVetBoolean0
38VIETNAMVETERAN SearchVietnam VeteranCB_VietnamBoolean0
39NOTESINDEX_I SearchNotes IndexDOLLARCurrency0
40CHANGEBY_I SearchChange BySTR15_User_IDString15
41CHANGEDATE_I SearchChange DateDTDate8
42OTHERVET SearchOther VeteransCB_OtherVetBoolean0
43AFSMVET SearchArmed Forces Service Medal VeteranCB_Armed_ForcesBoolean0
44RECSEPVET SearchRecently-Separated VeteranCB_Recently_Sep_VetBoolean0
45INET1 SearchINet1STR200String200
46DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsHuman Resources (414)SystemArchive_HR_Applicant (AHR2AP12)

Leave a Reply

Your email address will not be published. Required fields are marked *