Versions Supported

  • AC v4.2


Templates Supported

  • Template_Training_2021_September.xlsx

  • Template_TrainingPersonnel_2021_September.xlsx


Dependencies

  • Personnel Assignments to Training cannot be completed if Training data is not available



Column and Title

Description

A. Facility Code

Required

Must be Unique

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.

B. Training Number

Required

Must be Unique

C. Course Type

Required

PROFILE - Type (Training and Conference Profile Subgroup < Personnel Security Profile Group). If you add a Course Type to the profile, or modify the Description of an existing Course Type, the Description must match what you enter in this cell
If left blank, it will throw an error.

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

D. Start Date

Required

Format: YYYY-MM-DD

E. End Date

Required

Format: YYYY-MM-DD

F. Training Title

Required

No specific formatting required

G. Status

Required

PROFILE - Status (Training and Conference 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, Pending, Inactive.

H. Location

Optional

No specific formatting required

I. Classification

Required

PROFILE - Clearance Classifications (in the Global profile group). Use the Description from the profile. If left blank, defaults to None. If you add a facility clearance to the profile, or modify an existing clearance, 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.

J. Access

Optional

PROFILE - Access Type (in the Global profile group). Use the Description from profile. If you add an access to the profile, 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.

Format: Separated with a comma and a space

Format Example: NATO, SCI, CNWDI

K. Sponsor SSN

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

A Personnel record with that SSN must exist in the Personnel Management module or the record will error out

l. Required Training

Optional

Allowed values are 1 (for Yes) or 0 (for No)
If left blank, defaults to No

M. External LMS ID

Optional

No specific formatting required

N. Training Material Link

Optional

No specific formatting required

O. Training Instructions

Optional

No specific formatting required

P. Remarks

Optional

No specific formatting required

 

 

Column and Title

Description

A. Training Number

Required

The Training Number must exist in the Training & Conference module prior to importing this template. Training can be imported via the Training template, or entered manually.

B. Employee SSN

Required

A Personnel record with that SSN must exist in the Personnel Management module or the record will error out

C. Date Assigned

Required

Format: YYYY-MM-DD

D. Date Completed

Required

Format: YYYY-MM-DD

E. Compliant Flag

Required

Allowed values are 1 (for Yes) or 0 (for No)
If left blank, defaults to No