Versions Supported

  • AC v4.05


Templates Supported

  • Template_Personnel_2021_March.xlsx



Column and Title

Description

A. SSN

Required

Must be Unique

Format: ###-##-####

B. First Name

Required

Note: Do not use this field for nicknames. Put nicknames in column I, Nickname

C. Last Name

Required

No specific formatting required.

D. Facility Code

Required

No 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

Required

This is the login ID employees use to sign in to Access Commander, and ViSi/Portal Commander Standard, if applicable.

F. Middle Name Initial

Optional

Either the Middle Initial or full Middle Name may be entered

G. Suffix

Optional

PROFILE - 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

Default Profile Descriptions: [blank], III, Jr., PhD, Sr..

H. Prefix

Optional

PROFILE - 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

Default Profile Descriptions: [blank], Dr., Gen., Miss, Mr., Mrs., Ms.

I. Nickname

Optional

No specific formatting required

J. Employee Number

Required

Text Field, length = 25. The employee number will populate as the Login ID, Column E, if a Login ID is not provided.

K. E-Mail

Required

Must be Unique

Format:  must be in e-mail format, including the @ sign (e.g., xxxxx@xxxxx.xxxx). Note:  If not known, can enter a dummy email (e.g., abc001@email.com, abc002@email.com).

l. Status

Required

PROFILE - 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 cell

Default Profile Descriptions: Active, InActive

M. Type

Required

PROFILE - 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 cell

Default Profile Descriptions: Consultant, Employee, Intern, Other, Partime, Sub Contractor, Temporary

N. Citizenship

Required

PROFILE - 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 cell

Default Profile Descriptions: ForeignPerson, Not Indicated, PermanentResident, USCitizen

O. Phone

Optional

No specific formatting required

P. Extension

Optional

No specific formatting required

Q. Cell Phone

Optional

No specific formatting required

R. Cell Phone Carrier

Optional

PROFILE - 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

Default Profile Descriptions: Sprint, T-Mobile, Unknown, Verizon Wireless

S. Fax

Optional

No specific formatting required

T. Hired Date

Optional

Format: MM-DD-YYYY

U. File Sign Date

Optional

Format: MM-DD-YYYY

V. Start Date

Optional

Format: MM-DD-YYYY

W. Consult. Agreement Expiring On

Optional

Format: MM-DD-YYYY

X. Termination Date

Optional

Format: MM-DD-YYYY

Y. Termination Letter

Optional

Allowed values are 1 (for Yes) or 0 (for No)

Z. Key Management Personnel

Optional

Allowed values are Y (for Yes) or N (for No)

AA. SCI

Optional

Allowed values are 1 (for Yes) or 0 (for No)

AB. Citizenship Verification

Optional

PROFILE - 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

Default Profile Descriptions: Birth Certificate, Form FS-240, Naturalization Certificate, Pending

AC. Enrolled in STEP?

Optional

Allowed values are Y (for Yes) or N (for No)

AD. Alert Start Date

Optional

Format: MM-DD-YYYY

AE. Alert End Date

Optional

Format: MM-DD-YYYY

AF. Alert Message

Optional

No specific formatting required

AG. Remarks

Optional

No specific formatting required

AH. Location

Optional

No specific formatting required

AI. Business Unit

Optional

No specific formatting required

AJ. Organization

Optional

No specific formatting required

AK. Division

Optional

No specific formatting required

AL. Group

Optional

No specific formatting required

AM. Labor Category

Optional

No specific formatting required

AN. Title

Optional

No specific formatting required

AO. Grade

Optional

No specific formatting required

AP. Project Number

Optional

No specific formatting required

AQ. Inbound Date

Optional

Format: MM-DD-YYYY

AR. Charge Number

Optional

No specific formatting required

AS. Amount

Optional

No specific formatting required

AT. Cost Center

Optional

No specific formatting required

AU. Last Audit Date

Optional

Format: MM-DD-YYYY

AV. Available Date

Optional

Format: MM-DD-YYYY

AW. Senior Management Official

Optional

Allowed values are Y (for Yes) or N (for No)

AX. Received Appointment Letter

Optional

Allowed values are Y (for Yes) or N (for No)

AY. Urinalysis Date

Optional

Format: MM-DD-YYYY

AZ. Office Symbol

Optional

No specific formatting required

BA. Rank

Optional

No specific formatting required

BB. Branch

Optional

PROFILE - 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 cell

Default Profile Descriptions: --, Air Force, Army, Marines, Navy

BC. Base Badge Number

Optional

No specific formatting required

BD. Issue Date

Optional

Format: MM-DD-YYYY

BE. Gender

Optional

System Defined Profile: Female, Male, Unknown

BF. City of Birth

Optional

No specific formatting required

BG. State of Birth

Optional

Use the two-letter state postal abbreviation or spell out the State Name

BH. County Province of Birth

Optional

No specific formatting required

BI. Country of Birth

Optional

PROFILE - 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 cell

Default Profile Descriptions: too many to list here. Please access the profile in Access Commander to review the descriptions.

BJ. Date of Birth

Optional

Format: MM-DD-YYYY

BK. Marital Status

Optional

PROFILE - 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 cell

Default Profile Descriptions: Divorced, Married, Separated, Single, Unknown, Widowed

BL. Naturalization Number

Optional

No specific formatting required

BM. Alien Greencard Number

Optional

No specific formatting required

BN. Nationality

Optional

PROFILE - 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 blank

Default Profile Descriptions: too many to list here. Please refer to the profile to view the Descriptions.

BO. Race

Optional

PROFILE - 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 blank

Default Profile Descriptions: --, African American, American Indian or Alaska Native, Asian, Hispanic or Latino, Native Hawaiian or Other Pacific Islander, Unknown, White

BP. Height

Optional

Format: feet.inches, e.g., 5.9

BQ. Weight

Optional

In pounds. Enter the Number, e.g., 150

BR. Eye Color

Optional

PROFILE - 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 blank

Default Profile Descriptions: --, Amber, Black, Blue, Brown, Green, Hazel, Unknown

BS. Hair Color

Optional

PROFILE - 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 blank

Default Profile Descriptions: --, Black, Brown, Gray, Unknown, White

BT. Drivers License Number

Optional

No specific formatting required

BU. State Issued

Optional

Use the two-letter state postal abbreviation or spell out the State Name

BV. Expiration Date

Optional

Format: MM-DD-YYYY

BW. Barcode

Optional

No specific formatting required

BX. Address 1

Optional

No specific formatting required

BY. Address 2

Optional

No specific formatting required

BZ. City

Optional

No specific formatting required

CA. State

Optional

Use the two-letter state postal abbreviation or spell out the State Name

CB. Zip Code

Optional

Enter the 5-digit Zip Code (do not include the -+4)

CC. Home Phone

Optional

No specific formatting required

CD. Personal E-Mail

Optional

No specific formatting required

CE. Pager Number

Optional

No specific formatting required

CF. Decal Number

Optional

No specific formatting required

CG. Plate Number

Optional

No specific formatting required

CH. State Issued

Optional

Use the two-letter state postal abbreviation or spell out the State Name

CI. Make

Optional

No specific formatting required

CJ. Model

Optional

No specific formatting required

CK. Color

Optional

No specific formatting required

CL. Badge Number

Optional

No specific formatting required

CM. Issue Date

Optional

Format: MM-DD-YYYY

CN. Expiration Date

Optional

Format: MM-DD-YYYY

CO. Badge Type

Optional

PROFILE - Badge Type (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a badge type to the profile, or modify an existing badge type, the Description must match what you enter in this cell

Default Profile Descriptions: Employee, Guard, Temporary, Visitor

CP. Pin Number

Optional

No specific formatting required

CQ. Date of Return

Optional

Format: MM-DD-YYYY

CR. User Defined Text Field 1

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

CS. User Defined Text Field 2

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

CT. User Defined Text Field 3

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

CU. User Defined Text Field 4

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

CV. User Defined Text Field 5

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

CW. User Defined Date Field 1

Optional

Format: MM-DD-YYYY

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

CX. User Defined Date Field 2

Optional

Format: MM-DD-YYYY

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

CY. User Defined Date Field 3

Optional

Format: MM-DD-YYYY

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

CZ. User Defined Date Field 4

Optional

Format: MM-DD-YYYY

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

DA. User Defined Date Field 5

Optional

Format: MM-DD-YYYY

Configure prior to import (System Setup > Field Labels > Personnel Management > Employee > User Defined Fields)

DB. Fingerprints Required

Optional

Allowed values are 1 (for Yes) or 0 (for No)

DC. Status

Optional

PROFILE - Fingerprint Status (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a fingerprint status to the profile, or modify an existing fingerprint status, the Description must match what you enter in this cell

Default Profile Descriptions: Pending, Submitted, Unknown

DD. Fingerprints Taken By

Optional

No specific formatting required

DE. Fingerprint Date

Optional

Format: MM-DD-YYYY

DF. Submission Type

Optional

PROFILE - Fingerprint Submission Type (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a submission type to the profile, or modify an existing submission type, the Description must match what you enter in this cell

Default Profile Descriptions: [blank], E-Mail, US Mail

DG. Submission Date

Optional

Format: MM-DD-YYYY

DH. Continuous Evaluation DCSA Status

Required

PROFILE - Continuous Evaluation Status (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a status to the profile, or modify an existing status, the Description must match what you enter in this cell

Default Profile Descriptions: In Evaluation, Submitted, Unknown

DI. Continuous Evaluation ODNI Status

Optional

PROFILE - Continuous Evaluation Status (Personnel Management Profile Subgroup < Personnel Security Profile Group). If you add a status to the profile, or modify an existing status, the Description must match what you enter in this cell

Default Profile Descriptions: In Evaluation, Submitted, Unknown

DJ. Date Submitted to DCSA

Optional

Format: MM-DD-YYYY

DK. Date DCSA Entered Into System

Optional

Format: MM-DD-YYYY

DL. Date Submitted to ODNI

Optional

Format: MM-DD-YYYY

DM. Date ODNI Entered Into System

Optional

Format: MM-DD-YYYY