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 TypeSQL DB LengthKeyable Length
1APPLICANTNUMBER_I SearchApplicant NumberDOLLARCurrency100
2SSN_I SearchISSNSTR15_Social_Security_NumberString1615
3LLASTNAME_I SearchLLast NameSTR20String2220
4FFIRSTNAME_I SearchFFirst NameSTR15_IString1615
5MIDLNAME SearchMiddle NameSTR15String1615
6ADDRESS1 SearchAddress 1STR60String6260
7ADDRESS2 SearchAddress 2STR60String6260
8CITY SearchCitySTR35String3635
9STATE SearchStateSTR30_StateString3029
10ZIPCODE_I SearchIZip CodeSTR10String1210
11COUNTRY SearchCountrySTR60String6260
12HOMEPHONE SearchHome PhoneSTR10_PhoneString2210
13WORKPHONE SearchWork PhoneSTR10_PhoneString2210
14EXT_I SearchExtSTR4_IString64
15ISEQUENCENUMBER_I SearchISequence NumberIINT2Integer22
16APPLYDATE_I SearchApply DateDTDate48
17REQUISITIONNUMBER_I SearchRequisition NumberINT60Long Integer46
18COMPANYCODE_I SearchCompany CodeSTR6_Payroll_CodeString86
19DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString86
20DEPARTMENTCODE_I SearchDepartment CodeSTR6_Payroll_CodeString86
21POSITIONCODE_I SearchPosition CodeSTR6_Payroll_CodeString86
22LOCATNID SearchLocation IDSTR15_Location_IDString1615
23STATUS0_I SearchStatus0DDL_Status_HRMInteger20
24REJECTREASON_I SearchReject ReasonDDL_Reject_ReasonInteger20
25DSCRIPTN SearchDescriptionSTR30String3230
26RELOCATION_I SearchRelocationGB_IInteger20
27REPLYLETTERSENT_I SearchReply Letter SentCB_ReplyBoolean20
28COLORCODE_I SearchColor CodeVS_Color_CodeInteger20
29COLORSTRING_I SearchColor StringISTR6String86
30REFSOURCEDDL_I SearchRef Source DDLDDL_Ref_SourceInteger20
31REFERENCESOURCE_I SearchReference SourceSTR30_I0String3230
32EEOGENDER_I SearchEEO GenderDDL_EEO_GenderInteger20
33EEOETHNICORIGIN_I SearchEEO Ethnic OriginDDL_EEO_Ethnic_OriginInteger20
34EEOAGE_I SearchEEO AgeDDL_EEO_AgeInteger20
35HANDICAPPED SearchHandicappedCB_HandicapBoolean20
36VETERAN SearchVeteranCB_MilitaryBoolean20
37DISABLEDVETERAN SearchDisabled VeteranCB_DisableVetBoolean20
38VIETNAMVETERAN SearchVietnam VeteranCB_VietnamBoolean20
39NOTESINDEX_I SearchNotes IndexDOLLARCurrency100
40CHANGEBY_I SearchChange BySTR15_User_IDString1615
41CHANGEDATE_I SearchChange DateDTDate48
42OTHERVET SearchOther VeteransCB_OtherVetBoolean20
43AFSMVET SearchArmed Forces Service Medal VeteranCB_Armed_ForcesBoolean20
44RECSEPVET SearchRecently-Separated VeteranCB_Recently_Sep_VetBoolean20
45INET1 SearchINet1STR200String202200
46DEX_ROW_ID Searchintint1010

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 *