Versions Supported
AC v4.12
AC v4.21
AC v4.31
Templates Supported
Template_Facility_2021_June.xlsx
Column and Title | Description |
A. Facility Code | RequiredMust be UniqueNo specific formatting required.If blank, upload fails. |
B. Organization Name | RequiredNo specific formatting required.If blank, upload fails. |
C. Possessing Facility | OptionalAllowed values are 1 (for Yes) or 0 (for No)If left blank, defaults to No. |
D. Cognizant Office | RequiredEnter the Cognizant Office Name. If blank, upload fails.The Cognizant Office record must be included in the DCSA Office module (System Administrator Mode > Corporate Management menu > DCSA Office module). Add the applicable office if it is not included as a default.If a Cognization Office does not apply, enter N/A (for Not Applicable). |
E. Facility Type | PROFILE – Type (Facility Management profile subgroup < Facility profile group). (e.g., Cage Code, Internal Code, Vessels).If left blank, defaults to Cage Code. Use the Description from profile. If you add a facility type to the profile, the Description must match what you enter in this cell.Default Profile Descriptions: Cage Code, Internal Code, Unknown |
F. Host or Customer Facility | OptionalHost or Customer (System managed profile - can’t be modified).If left blank, defaults to Host. |
G. Status | RequiredPROFILE – Status Type (Facility Management profile subgroup < Facility profile group). Use the Description from the profile. If you add a facility status to the profile, or modify an existing status, the Description must match what you enter in this cell.Default Profile Descriptions: Active, InActive |
H. Division | OptionalNo specific formatting required |
I. Facility Clearance | RequiredPROFILE - 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. Facility Access(es) | OptionalPROFILE - Access Type (in the Global profile group). Use the Description from profile. If you add a facility 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. |
K. Clearance Date | OptionalFormat: YYYY-MM-DD |
l. Safeguard | RequiredPROFILE - Facility Safeguard (Facility Management profile subgroup < Facility profile group). If left blank, defaults to None. If you add a facility safeguard to the profile, the Description must match what you enter in this cell (If the applicable owner is not available for selection, you can add the owner in the Clearance Owner Global profile first, and then return to this profile to add the facility safeguard).Default Profile Descriptions: Confidential, Interim Secret, Interim Top Secret, None, Secret, Top Secret, TS/SCI |
M. Safeguard Access(es) | OptionalPROFILE - Access Type (in the Global profile group). Use the Description from profile. If you add a facility 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. |
N. Safeguard Date | OptionalFormat: YYYY-MM-DD |
O. DUNS Number | OptionalNo specific formatting required |
P. DUNS Date | OptionalFormat: YYYY-MM-DD |
Q. SAM Account Number | OptionalNo specific formatting required |
R. SAM Account Date | OptionalFormat: YYYY-MM-DD |
S. Ignore Safe when assigning document(s) to custodian(s) | OptionalAllowed values are 1 (for Yes) or 0 (for No). |
T. Remarks | OptionalNo specific formatting required |
U. Address 1(for Physical Address) | OptionalNo specific formatting required |
V. Address 2(for Physical Address) | OptionalNo specific formatting required |
W. City(for Physical Address) | RequiredNo specific formatting required |
X. State(for Physical Address) | RequiredUse the two-letter state postal abbreviation or spell out the state name. |
Y. Zip Code(for Physical Address) | OptionalEnter the 5-digit zip code (do not include the -+4) |
Z. Country(for Physical Address) | OptionalPROFILE – Country (Global profile group). Needs to match the Description in the Country profile, e.g., United States. If you add a country, or modify an existing country description, 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. |
AA. Phone(for Physical Address) | OptionalNo specific formatting required |
AB. Fax(for Physical Address) | OptionalNo specific formatting required |
AC. Address 1(for Mailing Address) | OptionalNo specific formatting required |
AD. Address 2(for Mailing Address) | OptionalNo specific formatting required |
AE. City(for Mailing Address) | OptionalNo specific formatting required |
AF. State(for Mailing Address) | OptionalUse the two-letter state postal abbreviation or spell out the state name. |
AG. Zip Code(for Mailing Address) | OptionalEnter the 5-digit zip code (do not include the -+4). |
AH. Country(for Mailing Address) | OptionalPROFILE – Country (Global profile group). Needs to match the Description in the Country profile, e.g., United States. If you add a country, or modify an existing country description, 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. |
AI. Phone(for Mailing Address) | OptionalNo specific formatting required |
AJ. Fax(for Mailing Address) | OptionalNo specific formatting required |
AK. Organization Name(for Classified Address) | OptionalNo specific formatting required |
AL. Division(for Classified Address) | OptionalNo specific formatting required |
AM. Address 1(for Classified Address) | OptionalNo specific formatting required |
AN. Address 2(for Classified Address) | OptionalNo specific formatting required |
AO. City(for Classified Address) | OptionalNo specific formatting required |
AP. State(for Classified Address) | OptionalUse the two-letter state postal abbreviation or spell out the state name. |
AQ. Zip Code(for Classified Address) | OptionalEnter the 5-digit zip code (do not include the -+4) |
AR. Country(for Classified Address) | OptionalPROFILE – Country (Global profile group). Needs to match the Description in the Country profile, e.g., United States. If you add a country, or modify an existing country description, 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. |
AS. Attention(for Classified Address) | OptionalNo specific formatting required |
AT. Phone(for Classified Address) | OptionalNo specific formatting required |
AU. Fax(for Classified Address) | OptionalNo specific formatting required |
AV. E-mail(for Classified Address) | OptionalNo specific formatting required |
AW. Organization Name(for Granted By Address) | OptionalNo specific formatting required |
AX. Division(for Granted By Address) | OptionalNo specific formatting required |
AY. Address 1(for Granted By Address) | OptionalNo specific formatting required |
AZ. Address 2(for Granted By Address) | OptionalNo specific formatting required |
BA. City(for Granted By Address) | OptionalNo specific formatting required |
BB. State(for Granted By Address) | OptionalUse the two-letter state postal abbreviation or spell out the state name. |
BC. Zip Code(for Granted By Address) | OptionalEnter the 5-digit zip code (do not include the -+4) |
BD. Country(for Granted By Address) | OptionalPROFILE – Country (Global profile group). Needs to match the Description in the Country profile, e.g., United States. If you add a country, or modify an existing country description, 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. |
BE. Attention(for Granted By Address) | OptionalNo specific formatting required |
BF. Phone(for Granted By Address) | OptionalNo specific formatting required |
BG. Fax(for Granted By Address) | OptionalNo specific formatting required |
BH. User Defined Text Field 1 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Facility Management > Facility Information > User Defined Fields) |
BI. User Defined Text Field 2 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Facility Management > Facility Information > User Defined Fields) |
BJ. User Defined Text Field 3 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Facility Management > Facility Information > User Defined Fields) |
BK. User Defined Text Field 4 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Facility Management > Facility Information > User Defined Fields) |
BL. User Defined Text Field 5 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Facility Management > Facility Information > User Defined Fields) |
Change Log
Last Updated: March 30, 2022
Set compatibility with v4.21 and v4.31 releases
Last Updated: June 8, 2021
Set compatibility with v4.12 release
Converted all Date fields to YYYY-MM-DD format for consistency
Converted all Boolean flags to 1 and 0 for consistency
Made Possessing Facility column optional instead of required