Versions Supported
AC v4.12
AC v4.21
AC v4.31
Templates Supported
Template_Contracts_2021_June.xlsx
Column and Title | Description |
A. Contract Number | RequiredMust be UniqueNo specific formatting required.Maximum Character Length: 60 |
B. Contract Name | RequiredNo specific formatting required.Maximum Character Length: 60 |
C. Contract Type | RequiredPROFILE – Type (Contracts profile group). If you add a Contract Type to the profile, or modify an existing Contract Type, the Description must match what you enter in this cell.Default Profile Descriptions: None, Prime, Cost Plus, Fixed Price, Sub (Unknowned), Subcontract Generated, Subcontract Received |
D. Prime Contract Number | RequiredMaximum Character Length: 60 |
E. Market Type | RequiredPROFILE – Market Type (Contracts profile group). If you add a Market Type to the profile, or modify an existing Market Type, the Description must match what you enter in this cell.Default Profile Descriptions: Airforce, Army, Military, Navy, Unknown |
F. PoP Start Date | RequiredFormat: YYYY-MM-DD |
G. PoP End Date | RequiredFormat: YYYY-MM-DD |
H. Status | RequiredPROFILE – Status (Contracts 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: Active, Closed, Closing |
I. Closing Action | RequiredPROFILE - Closing Actions (Contracts profile group). If you add a Closing Action to the profile, or modify an existing Closing Action, the Description must match what you enter in this cell.Default Profile Descriptions: --, No Material, Retention, Transfer |
J. Facility Security Clearance (FCL) | RequiredPROFILE - Clearance Classifications (in the Global profile group). Use the Description from the profile. If you add a 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. |
K. Safeguarding for Classified Information/Material | RequiredPROFILE - Facility Safeguard (Facility Management profile subgroup < Facility profile group). Use the Description from the profile. If you add a 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. |
L. Interim Clearance Allowed | OptionalAllowed values are Yes, No or N/A |
M. Poly Type Required | OptionalPROFILE - Polygraph - Type (Personnel Management profile subgroup < Personnel Security profile group). Use the Description from the profile. If you add a Polygraph to the profile, or modify an existing Polygraph, the Description must match what you enter in this cell. |
N. Incidents Must be Reported | OptionalAllowed values are Yes, No or N/A |
O. Lawful/Legal Permanent Resident Allowed | OptionalAllowed values are Yes, No or N/A |
P. Authorized Alien/Work Visa | OptionalAllowed values are Yes, No or N/A |
Q. US Citizenship | OptionalAllowed values are Yes, No or N/A |
R. Facility Code | RequiredNo specific formatting requiredThe Host 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. |
S. Customer Facility | RequiredNo specific formatting requiredThe Customer 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. |
T. DD 254 Template | RequiredAllowed values are 1999, 2017, 2018, 2019 |
U. GovWin ID | OptionalNo specific formatting required |
V. Internal Contract Number | OptionalNo specific formatting required |
W. Task Order Number | OptionalNo specific formatting required |
X. Contract Alias Name | OptionalNo specific formatting required |
Y. Subcontract # | OptionalNo specific formatting required |
Z. Prime Task Leader | OptionalNo specific formatting required |
AA. Reciprocity | OptionalAllowed Values are 1 (for Yes) and 0 (for No) |
AB. Contract Primary Type | OptionalNo specific formatting required |
AC. Cost Accounting Code | OptionalNo specific formatting required |
AD. Statement of Work | OptionalNo specific formatting required |
AE. Retention Date | OptionalFormat: YYYY-MM-DD |
AF. Closeout Date | OptionalFormat: YYYY-MM-DD |
AG. Contract Rep (COR) Name | OptionalNo specific formatting required |
AH. Contract Rep (COR) E-Mail | OptionalFormat: must be in e-mail format, including the @ sign (e.g., xxxxx@xxxxx.xxxx). |
AI. Contract Rep (COR) Phone | OptionalNo specific formatting required |
AJ. COR Org | OptionalNo specific formatting required |
AK. DD254 Date | OptionalFormat: YYYY-MM-DD |
AL. Actual Performance Facility Code | OptionalNo specific formatting required.The Host/Customer 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. |
AM. Ignore Personnel Clearance when Assigning | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
AN. End User | OptionalNo specific formatting required |
AO. Customer Name | OptionalNo specific formatting required |
AP. Buyer Name | OptionalNo specific formatting required |
AQ. Buyer E-Mail | OptionalFormat: must be in e-mail format, including the @ sign (e.g., xxxxx@xxxxx.xxxx). |
AR. Buyer Address 1 | OptionalNo specific formatting required |
AS. Buyer Address 2 | OptionalNo specific formatting required |
AT. Buyer Address 3 | OptionalNo specific formatting required |
AU. Buyer City | OptionalNo specific formatting required |
AV. Buyer State | OptionalUse the two-letter state postal abbreviation or spell out the State Name |
AW. Buyer Zip Code | OptionalEnter the 5-digit Zip Code (do not include the -+4) |
AX. Buyer Country | OptionalPROFILE - Country (Global Profile Group). Use the Description from the profile. If you add a clearance to the profile, or modify an existing 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. |
AY. Buyer Phone | OptionalNo specific formatting required |
AZ. Buyer Fax | OptionalNo specific formatting required |
BA. Name(Customer's Technical POC) | OptionalNo specific formatting required |
BB. E-Mail(Customer's Technical POC) | OptionalFormat: must be in e-mail format, including the @ sign (e.g., xxxxx@xxxxx.xxxx). |
BC. Address 1(Customer's Technical POC) | OptionalNo specific formatting required |
BD. Address 2(Customer's Technical POC) | OptionalNo specific formatting required |
BE. Address 3(Customer's Technical POC) | OptionalNo specific formatting required |
BF. City(Customer's Technical POC) | OptionalNo specific formatting required |
BG. State(Customer's Technical POC) | OptionalUse the two-letter state postal abbreviation or spell out the State Name |
BH. Zip(Customer's Technical POC) | OptionalEnter the 5-digit Zip Code (do not include the -+4) |
BI. Country(Customer's Technical POC) | OptionalPROFILE - Country (Global Profile Group). Use the Description from the profile. If you add a clearance to the profile, or modify an existing 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. Phone(Customer's Technical POC) | OptionalNo specific formatting required |
BK. Fax(Customer's Technical POC) | OptionalNo specific formatting required |
BL. User Defined Date Field 1 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BM. User Defined Date Field 2 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BN. User Defined Date Field 3 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BO. User Defined Date Field 4 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BP. User Defined Date Field 5 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BQ. User Defined Date Field 6 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BR. User Defined Date Field 7 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BS. User Defined Date Field 8 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BT. User Defined Date Field 9 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BU. User Defined Date Field 10 | OptionalFormat: YYYY-MM-DDConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BV. User Defined Text Field 1 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BW. User Defined Text Field 2 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BX. User Defined Text Field 3 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BY. User Defined Text Field 4 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
BZ. User Defined Text Field 5 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CA. User Defined Text Field 6 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CB. User Defined Text Field 7 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CC. User Defined Text Field 8 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CD. User Defined Text Field 9 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CE. User Defined Text Field 10 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CF. User Defined Text Field 11 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CG. User Defined Text Field 12 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CH. User Defined Text Field 13 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CI. User Defined Text Field 14 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CJ. User Defined Text Field 15 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CK. User Defined Text Field 16 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CL. User Defined Text Field 17 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CM. User Defined Text Field 18 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CN. User Defined Text Field 19 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CO. User Defined Text Field 20 | OptionalText FieldConfigure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields) |
CP. a. Communications Security (COMSEC) Information(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CQ. b. Restricted Area(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CR. c. Critical Nuclear Weapon Design Information (CNWDI)(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CS. d. Formerly Restricted Data(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CT. 1. Sensitive Compartment Information (SCI)(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CU. 2. Non-SCI(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CV. f. Special Access Program (SAP) Information(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CW. g. North Atlantic Treaty Organization(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CX. h. Foreign Government Information(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CY. i. Alternative Compensatory Control Measures (ACCM) Information(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
CZ. i. Limited Dissemination Information(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DA. j. Controlled Unclassified Information(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DB. j. For Official Use Only Information(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DC. k. Other(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DD. l. AIS(Section 10 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DE. a. Have Access to Classified Information only at another Contractor’s Facility or a Government Activity(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DF. b. Receive and Store Classified Documents Only(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DG. c. Receive, Store and Generate Classified Information or Material(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DH. d. Fabricate, Modify, or Store Classified Hardware(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DI. e. Perform Services Only(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DJ. f. Have access to U.S. Classified Information outside the U.S., Puerto Rico, U.S. Possessions and Trust Territories(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DK. g. Be Authorized to use the Services of Defense Technical Information Center (DTIC) or Other Secondary Distribution Center(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DL. h. Require a COMSEC Account(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DM. i. Have a TEMPEST Requirement(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DN. j. Have Operations Security (OPSEC) Requirements(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DO. k. Be Authorized to Use Defense Courier Service(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DP. l. Receive, Store, or Generate Controlled Unclassified Information (CUI)(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DQ. m. Other(Section 11 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DR. Direct(Section 12 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DS. Through(Section 12 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DT. Public Release Authority(Section 12 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
DU. Remarks(Section 12 of DD 254) | OptionalNo specific formatting required |
DV. Remarks(Section 13 of DD 254) | OptionalNo specific formatting required |
DW. YES/NO(Section 14 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DX. Remarks(Section 14 of DD 254) | OptionalNo specific formatting required |
DY. YES/NO(Section 15 of DD 254) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
DZ. Remarks(Section 15 of DD 254) | OptionalNo specific formatting required |
EA. GCA Name(Section 16 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EB. Activity Address Code (AAC) of the Contracting Office(Section 16 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EC. Address(Section 16 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
ED. POC Name(Section 16 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EE. POC Telephone(Section 16 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EF. E-Mail Address(Section 16 of DD 254 2017, 2018 and 2019) | OptionalFormat: must be in e-mail format, including the @ sign (e.g., xxxxx@xxxxx.xxxx). |
EG. Typed Name of Certifying Official(Section 16 of DD 254 1999)(Section 17 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EH. Title(Section 16 of DD 254 1999)(Section 17 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EI. Address(Section 16 of DD 254 1999)(Section 17 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EJ. AAC of the Contracting Office(Section 16 of DD 254 1999)(Section 17 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EK. Cage Code of the Prime Contractor(Section 16 of DD 254 1999)(Section 17 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EL. Telephone(Section 16 of DD 254 1999)(Section 17 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EM. E-Mail Address(Section 16 of DD 254 1999)(Section 17 of DD 254 2017, 2018 and 2019) | OptionalFormat: must be in e-mail format, including the @ sign (e.g., xxxxx@xxxxx.xxxx). |
EN. Date(Section 16 of DD 254 1999)(Section 17 of DD 254 2017, 2018 and 2019) | OptionalFormat: YYYY-MM-DD |
EO. Contractor(Section 17 of DD 254 1999)(Section 18 of DD 254 2017, 2018 and 2019) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
EP. Subcontractor(Section 17 of DD 254 1999)(Section 18 of DD 254 2017, 2018 and 2019) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
EQ. Cognizant Security Office for Prime and SubContractor(Section 17 of DD 254 1999)(Section 18 of DD 254 2017, 2018 and 2019) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
ER. U.S. Activity Responsible for Overseas Security Administration(Section 17 of DD 254 1999)(Section 18 of DD 254 2017, 2018 and 2019) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
ES. Administrative Contracting Office(Section 17 of DD 254 1999)(Section 18 of DD 254 2017, 2018 and 2019) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
ET. Others as necessary(Section 17 of DD 254 1999)(Section 18 of DD 254 2017, 2018 and 2019) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
EU. Other(Section 17 of DD 254 1999)(Section 18 of DD 254 2017, 2018 and 2019) | OptionalNo specific formatting required |
EV. Client Authorization Required for Public Release of Contract Information | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
EW. Protected Health Information (PHI) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
EX. Personally Identifiable Information (PII) | OptionalAllowed Values are 1 (for Yes) or 0 (for No) |
EY. Type of Government Credentials Issued | OptionalPROFILE – Government Credential Issues (Contracts profile group). If you add a Government Credentials to the profile, or modify an existing Government Credentials, the Description must match what you enter in this cell. |
EZ. Training Requirements | OptionalPROFILE – Security Training Requirements (Contracts profile group). If you add a Security Training to the profile, or modify an existing Security Training, the Description must match what you enter in this cell. |
FA. Corporate Security Remarks | Optional |
FB. Field Office Remarks | Optional |
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 the following columns optional instead of required [Interim Clearance Allowed; Poly Type Required; Incidents Must be Reported; Lawful/Legal Permanent Resident Allowed; Authorized Alien/Work Visa; US Citizenship Required]