Versions Supported
AC v4.31
Templates Supported
Template_Personnel_2021_December.xlsx
Column and Title | Description |
A. SSN | RequiredMust be UniqueFormat: ###-##-#### |
B. First Name | RequiredNote: Do not use this field for nicknames. Put nicknames in column I, Nickname |
C. Last Name | RequiredNo specific formatting required. |
D. Facility Code | RequiredNo specific formatting required. The facility code must exist in the Facility Management module prior to importing this template. Facilities can be imported via the Facility Information template, or entered manually. |
E. Login ID | RequiredText field with a maximum length of 384 characters |
F. Middle Name Initial | OptionalEither the Middle Initial or full Middle Name may be entered |
G. Suffix | OptionalPROFILE - Suffix (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a suffix to the profile, or modify the Description of an existing suffix, the Description must match what you enter in this cell |
H. Prefix | OptionalPROFILE - Prefix (Personnel Management Profile Subgroup < Personnel Security Profile Group) If you add a prefix to the profile, or modify the Description of an existing prefix, the Description must match what you enter in this cell. |
I. Nickname | OptionalNo specific formatting required |
J. Employee Number | OptionalText Field with a maximum length of 25 characters |
K. E-Mail | RequiredMust be UniqueText Field with a maximum length of 384 characters |
l. Status | RequiredPROFILE - Status (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a status to the profile, or modify the Description of an existing status, the Description must match what you enter in this cellDefault Profile Descriptions: Active, InActive |
M. Type | RequiredPROFILE - Type (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add an employee type to the profile, or modify the Description of an existing employee type, the Description must match what you enter in this cellDefault Profile Descriptions: Consultant, Employee, Intern, Other, Partime, Sub Contractor, Temporary |
N. Citizenship | RequiredPROFILE - Citizenship Description (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a citizenship description to the profile, or modify the description of an existing citizenship Description, the Description must match what you enter in this cellDefault Profile Descriptions: Foreign Person, Not Indicated, Permanent Resident, US Citizen |
O. Phone | OptionalNo specific formatting required |
P. Extension | OptionalNo specific formatting required |
Q. Cell Phone | OptionalNo specific formatting required |
R. Cell Phone Carrier | OptionalPROFILE - Cell Phone Carrier (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a cell phone carrier to the profile, or modify the Description of an existing cell phone carrier, the Description must match what you enter in this cell |
S. Fax | OptionalNo specific formatting required |
T. Hired Date | OptionalFormat: YYYY-MM-DD |
U. File Sign Date | OptionalFormat: YYYY-MM-DD |
V. Start Date | OptionalFormat: YYYY-MM-DD |
W. Consult. Agreement Expiring On | OptionalFormat: YYYY-MM-DD |
X. Termination Date | OptionalFormat: YYYY-MM-DD |
Y. Termination Letter | OptionalAllowed values are 1 (for Yes) or 0 (for No) |
Z. Key Management Personnel | OptionalAllowed values are 1 (for Yes) or 0 (for No) |
AA. SCI | OptionalAllowed values are 1 (for Yes) or 0 (for No) |
AB. Citizenship Verification | OptionalPROFILE - Citizenship Verification (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a citizenship verification to the profile, or modify the Description of an existing citizenship verification, the Description must match what you enter in this cell |
AC. Enrolled in STEP? | OptionalAllowed values are 1 (for Yes) or 0 (for No) |
AD. Alert Start Date | OptionalFormat: YYYY-MM-DD |
AE. Alert End Date | OptionalFormat: YYYY-MM-DD |
AF. Alert Message | OptionalNo specific formatting required |
AG. Remarks | OptionalNo specific formatting required |
AH. Location | OptionalNo specific formatting required |
AI. Business Unit | OptionalNo specific formatting required |
AJ. Organization | OptionalNo specific formatting required |
AK. Division | OptionalNo specific formatting required |
AL. Group | OptionalNo specific formatting required |
AM. Labor Category | OptionalNo specific formatting required |
AN. Title | OptionalNo specific formatting required |
AO. Grade | OptionalNo specific formatting required |
AP. Project Number | OptionalNo specific formatting required |
AQ. Inbound Date | OptionalFormat: YYYY-MM-DD |
AR. Charge Number | OptionalNo specific formatting required |
AS. Amount | OptionalNo specific formatting required |
AT. Cost Center | OptionalNo specific formatting required |
AU. Last Audit Date | OptionalFormat: YYYY-MM-DD |
AV. Available Date | OptionalFormat: YYYY-MM-DD |
AW. Senior Management Official | OptionalAllowed values are 1 (for Yes) or 0 (for No) |
AX. Received Appointment Letter | OptionalAllowed values are 1 (for Yes) or 0 (for No) |
AY. Urinalysis Date | OptionalFormat: YYYY-MM-DD |
AZ. Office Symbol | OptionalNo specific formatting required |
BA. Rank | OptionalNo specific formatting required |
BB. Branch | OptionalPROFILE - Service Branch (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a branch to the profile, or modify the Description of an existing branch, the Description must match what you enter in this cellDefault Profile Descriptions: --, Air Force, Army, Marines, Navy |
BC. Base Badge Number | OptionalNo specific formatting required |
BD. Issue Date | OptionalFormat: YYYY-MM-DD |
BE. Gender | OptionalSystem Defined Profile: Female, Male, Unknown |
BF. City of Birth | OptionalNo specific formatting required |
BG. State of Birth | OptionalFormat: Spell out the State Name |
BH. County Province of Birth | OptionalNo specific formatting required |
BI. Country of Birth | OptionalPROFILE - Country (Global Profile Group) Needs to match the Description in the Country profile, e.g., United States (Global Profile Group). If you add or modify a country, the Description must match what you enter in this cellDefault Profile Descriptions: too many to list here. Please access the profile in Access Commander to review the descriptions. |
BJ. Date of Birth | OptionalFormat: YYYY-MM-DD |
BK. Marital Status | OptionalPROFILE - Marital Status (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a marital status to the profile, or modify the Description of an existing marital status, the Description must match what you enter in this cellDefault Profile Descriptions: Divorced, Married, Separated, Single, Unknown, Widowed |
BL. Naturalization Number | OptionalNo specific formatting required |
BM. Alien Greencard Number | OptionalNo specific formatting required |
BN. Nationality | OptionalPROFILE - Nationality (Global Profile Group). If you add a nationality description to the profile, or modify an existing nationality, the Description must match what you enter in this cell. One of the default Descriptions is --. If two dashes are entered in this cell, the two dashes will display in the Nationality field - the value will be blankDefault Profile Descriptions: too many to list here. Please refer to the profile to view the Descriptions. |
BO. Race | OptionalPROFILE - Race (Global Profile Group). If you add a race description to the profile, or modify an existing race, the Description must match what you enter in this cell. One of the default Descriptions is --. If two dashes are entered in this cell, the two dashes will display in the Race field - the value will be blankDefault Profile Descriptions: --, African American, American Indian or Alaska Native, Asian, Hispanic or Latino, Native Hawaiian or Other Pacific Islander, Unknown, White |
BP. Height | OptionalFormat: feet.inches, e.g., 5.9 |
BQ. Weight | OptionalIn pounds. Enter the Number, e.g., 150 |
BR. Eye Color | OptionalPROFILE - Eye Color (Global Profile Group). If you add an eye color to the profile, or modify an existing eye color, the Description must match what you enter in this cell. One of the default Descriptions is --. If two dashes are entered in this cell, the two dashes will display in the Eye Color field - the value will be blankDefault Profile Descriptions: --, Amber, Black, Blue, Brown, Green, Hazel, Unknown |
BS. Hair Color | OptionalPROFILE - Hair Color (Global Profile Group). If you add a hair color description to the profile, or modify an existing hair color, the Description must match what you enter in this cell. One of the default Descriptions is --. If two dashes are entered in this cell, the two dashes will display in the Hair Color field - the value will be blankDefault Profile Descriptions: --, Black, Brown, Gray, Unknown, White |
BT. Drivers License Number | OptionalNo specific formatting required |
BU. State Issued | OptionalFormat: Spell out the State Name |
BV. Expiration Date | OptionalFormat: YYYY-MM-DD |
BW. Barcode | OptionalNo specific formatting required |
BX. Address 1 | OptionalNo specific formatting required |
BY. Address 2 | OptionalNo specific formatting required |
BZ. City | OptionalNo specific formatting required |
CA. State | OptionalFormat: Spell out the State Name |
CB. Zip Code | OptionalEnter the 5-digit Zip Code (do not include the -+4) |
CC. Home Phone | OptionalNo specific formatting required |
CD. Personal E-Mail | OptionalNo specific formatting required |
CE. Pager Number | OptionalNo specific formatting required |
CF. Decal Number | OptionalNo specific formatting required |
CG. Plate Number | OptionalNo specific formatting required |
CH. State Issued | OptionalFormat: Spell out the State Name |
CI. User Defined Text Field 1 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
CJ. User Defined Text Field 2 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
CK. User Defined Text Field 3 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
CL. User Defined Text Field 4 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
CM. User Defined Text Field 5 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
CN. User Defined Date Field 1 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
CO. User Defined Date Field 2 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
CP. User Defined Date Field 3 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
CQ. User Defined Date Field 4 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
CR. User Defined Date Field 5 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields) |
Change Log
Last Updated: December 6, 2022
For columns of the state name, modified instructions that name of state must be spelled out
Last Updated: March 30, 2022
Set compatibility with v4.31 release
Last Updated: December 6, 2021
Made Employee Number column optional instead of required
Dropped several columns related to Continuous Evaluation since DISS provides accurate data