Versions Supported

  • AC v4.12


Templates Supported

  • Template_Contracts_2021_June.xlsx



Column and Title

Description

A. Contract Number

Required

Must be Unique

No specific formatting required.

Maximum Character Length: 60

B. Contract Name

Required

No specific formatting required.

Maximum Character Length: 60

C. Contract Type

Required

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

Required

Maximum Character Length: 60

E. Market Type

Required

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

Required

Format: YYYY-MM-DD

G. PoP End Date

Required

Format: YYYY-MM-DD

H. Status

Required

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

Required

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

Required

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

Required

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

Optional

Allowed values are Yes, No or N/A
If left blank, defaults to N/A

M. Poly Type Required

Optional

PROFILE - 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.
If left blank, defaults to Unknown

Default Profile Descriptions: CI, Electroscopic, LS, Type I, Type II, Unknown

N. Incidents Must be Reported

Optional

Allowed values are Yes, No or N/A
If left blank, defaults to N/A

O. Lawful/Legal Permanent Resident Allowed

Optional

Allowed values are Yes, No or N/A
If left blank, defaults to N/A

P. Authorized Alien/Work Visa

Optional

Allowed values are Yes, No or N/A
If left blank, defaults to N/A

Q. US Citizenship

Optional

Allowed values are Yes, No or N/A
If left blank, defaults to N/A

R. Facility Code

Required

No specific formatting required

The 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

Required

No specific formatting required

The 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

Required

Allowed values are 1999, 2017, 2018, 2019

U. GovWin ID

Optional

No specific formatting required

V. Internal Contract Number

Optional

No specific formatting required

W. Task Order Number

Optional

No specific formatting required

X. Contract Alias Name

Optional

No specific formatting required

Y. Subcontract #

Optional

No specific formatting required

Z. Prime Task Leader

Optional

No specific formatting required

AA. Reciprocity

Optional

Allowed Values are 1 (for Yes) and 0 (for No)
If left blank, defaults to No

AB. Contract Primary Type

Optional

No specific formatting required

AC. Cost Accounting Code

Optional

No specific formatting required

AD. Statement of Work

Optional

No specific formatting required

AE. Retention Date

Optional

Format: YYYY-MM-DD

AF. Closeout Date

Optional

Format: YYYY-MM-DD

AG. Contract Rep (COR) Name

Optional

No specific formatting required

AH. Contract Rep (COR) E-Mail

Optional

Format: must be in e-mail format, including the @ sign (e.g., xxxxx@xxxxx.xxxx).

AI. Contract Rep (COR) Phone

Optional

No specific formatting required

AJ. COR Org

Optional

No specific formatting required

AK. DD254 Date

Optional

Format: YYYY-MM-DD

AL. Actual Performance Facility Code

Optional

No 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

Optional

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

AN. End User

Optional

No specific formatting required

AO. Customer Name

Optional

No specific formatting required

AP. Buyer Name

Optional

No specific formatting required

AQ. Buyer E-Mail

Optional

Format: must be in e-mail format, including the @ sign (e.g., xxxxx@xxxxx.xxxx).

AR. Buyer Address 1

Optional

No specific formatting required

AS. Buyer Address 2

Optional

No specific formatting required

AT. Buyer Address 3

Optional

No specific formatting required

AU. Buyer City

Optional

No specific formatting required

AV. Buyer State

Optional

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

AW. Buyer Zip Code

Optional

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

AX. Buyer Country

Optional

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

Optional

No specific formatting required

AZ. Buyer Fax

Optional

No specific formatting required

BA. Name

(Customer's Technical POC)

Optional

No specific formatting required

BB. E-Mail

(Customer's Technical POC)

Optional

Format: must be in e-mail format, including the @ sign (e.g., xxxxx@xxxxx.xxxx).

BC. Address 1

(Customer's Technical POC)

Optional

No specific formatting required

BD. Address 2

(Customer's Technical POC)

Optional

No specific formatting required

BE. Address 3

(Customer's Technical POC)

Optional

No specific formatting required

BF. City

(Customer's Technical POC)

Optional

No specific formatting required

BG. State

(Customer's Technical POC)

Optional

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

BH. Zip

(Customer's Technical POC)

Optional

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

BI. Country

(Customer's Technical POC)

Optional

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

Optional

No specific formatting required

BK. Fax

(Customer's Technical POC)

Optional

No specific formatting required

BL. User Defined Date Field 1

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BM. User Defined Date Field 2

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BN. User Defined Date Field 3

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BO. User Defined Date Field 4

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BP. User Defined Date Field 5

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BQ. User Defined Date Field 6

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BR. User Defined Date Field 7

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BS. User Defined Date Field 8

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BT. User Defined Date Field 9

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BU. User Defined Date Field 10

Optional

Format: YYYY-MM-DD

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BV. User Defined Text Field 1

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BW. User Defined Text Field 2

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BX. User Defined Text Field 3

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BY. User Defined Text Field 4

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

BZ. User Defined Text Field 5

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CA. User Defined Text Field 6

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CB. User Defined Text Field 7

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CC. User Defined Text Field 8

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CD. User Defined Text Field 9

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CE. User Defined Text Field 10

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CF. User Defined Text Field 11

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CG. User Defined Text Field 12

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CH. User Defined Text Field 13

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CI. User Defined Text Field 14

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CJ. User Defined Text Field 15

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CK. User Defined Text Field 16

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CL. User Defined Text Field 17

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CM. User Defined Text Field 18

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CN. User Defined Text Field 19

Optional

Text Field

Configure prior to import (System Setup > Field Labels > Contracts Management > Contract Information > User Defined Fields)

CO. User Defined Text Field 20

Optional

Text Field

Configure 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)

Optional

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

CQ. b. Restricted Area

(Section 10 of DD 254)

Optional

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

CR. c. Critical Nuclear Weapon Design Information (CNWDI)

(Section 10 of DD 254)

Optional

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

CS. d. Formerly Restricted Data

(Section 10 of DD 254)

Optional

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

CT. 1. Sensitive Compartment Information (SCI)

(Section 10 of DD 254)

Optional

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

CU. 2. Non-SCI

(Section 10 of DD 254)

Optional

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

CV. f. Special Access Program (SAP) Information

(Section 10 of DD 254)

Optional

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

CW. g. North Atlantic Treaty Organization

(Section 10 of DD 254)

Optional

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

CX. h. Foreign Government Information

(Section 10 of DD 254)

Optional

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

CY. i. Alternative Compensatory Control Measures (ACCM) Information

(Section 10 of DD 254)

Optional

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

This is applicable to DD254 2017, 2018 and 2019

CZ. i. Limited Dissemination Information

(Section 10 of DD 254)

Optional

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

This is applicable to DD254 1999 only

DA. j. Controlled Unclassified Information

(Section 10 of DD 254)

Optional

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

This is applicable to DD254 2017, 2018 and 2019

DB. j. For Official Use Only Information

(Section 10 of DD 254)

Optional

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

This is applicable to DD254 1999 only

DC. k. Other

(Section 10 of DD 254)

Optional

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

DD. l. AIS

(Section 10 of DD 254)

Optional

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

DE. a. Have Access to Classified Information only at another Contractor’s Facility or a Government Activity

(Section 11 of DD 254)

Optional

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

DF. b. Receive and Store Classified Documents Only

(Section 11 of DD 254)

Optional

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

DG. c. Receive, Store and Generate Classified Information or Material

(Section 11 of DD 254)

Optional

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

DH. d. Fabricate, Modify, or Store Classified Hardware

(Section 11 of DD 254)

Optional

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

DI. e. Perform Services Only

(Section 11 of DD 254)

Optional

Allowed Values are 1 (for Yes) or 0 (for No)
If left blank, defaults to 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)

Optional

Allowed Values are 1 (for Yes) or 0 (for No)
If left blank, defaults to 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)

Optional

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

DL. h. Require a COMSEC Account

(Section 11 of DD 254)

Optional

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

DM. i. Have a TEMPEST Requirement

(Section 11 of DD 254)

Optional

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

DN. j. Have Operations Security (OPSEC) Requirements

(Section 11 of DD 254)

Optional

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

DO. k. Be Authorized to Use Defense Courier Service

(Section 11 of DD 254)

Optional

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

DP. l. Receive, Store, or Generate Controlled Unclassified Information (CUI)

(Section 11 of DD 254)

Optional

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

This is applicable to DD254 2017, 2018 and 2019

DQ. m. Other

(Section 11 of DD 254)

Optional

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

DR. Direct

(Section 12 of DD 254)

Optional

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

DS. Through

(Section 12 of DD 254)

Optional

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

DT. Public Release Authority

(Section 12 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

DU. Remarks

(Section 12 of DD 254)

Optional

No specific formatting required

DV. Remarks

(Section 13 of DD 254)

Optional

No specific formatting required

DW. YES/NO

(Section 14 of DD 254)

Optional

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

DX. Remarks

(Section 14 of DD 254)

Optional

No specific formatting required

DY. YES/NO

(Section 15 of DD 254)

Optional

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

DZ. Remarks

(Section 15 of DD 254)

Optional

No specific formatting required

EA. GCA Name

(Section 16 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

EB. Activity Address Code (AAC) of the Contracting Office

(Section 16 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

EC. Address

(Section 16 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

ED. POC Name

(Section 16 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

EE. POC Telephone

(Section 16 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

EF. E-Mail Address

(Section 16 of DD 254 2017, 2018 and 2019)

Optional

Format: 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)

Optional

No specific formatting required

EH. Title

(Section 16 of DD 254 1999)

(Section 17 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

EI. Address

(Section 16 of DD 254 1999)

(Section 17 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

EJ. AAC of the Contracting Office

(Section 16 of DD 254 1999)

(Section 17 of DD 254 2017, 2018 and 2019)

Optional

No 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)

Optional

No specific formatting required

EL. Telephone

(Section 16 of DD 254 1999)

(Section 17 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

EM. E-Mail Address

(Section 16 of DD 254 1999)

(Section 17 of DD 254 2017, 2018 and 2019)

Optional

Format: 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)

Optional

Format: YYYY-MM-DD

EO. Contractor

(Section 17 of DD 254 1999)

(Section 18 of DD 254 2017, 2018 and 2019)

Optional

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

EP. Subcontractor

(Section 17 of DD 254 1999)

(Section 18 of DD 254 2017, 2018 and 2019)

Optional

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

EQ. Cognizant Security Office for Prime and SubContractor

(Section 17 of DD 254 1999)

(Section 18 of DD 254 2017, 2018 and 2019)

Optional

Allowed Values are 1 (for Yes) or 0 (for No)
If left blank, defaults to 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)

Optional

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

ES. Administrative Contracting Office

(Section 17 of DD 254 1999)

(Section 18 of DD 254 2017, 2018 and 2019)

Optional

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

ET. Others as necessary

(Section 17 of DD 254 1999)

(Section 18 of DD 254 2017, 2018 and 2019)

Optional

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

EU. Other

(Section 17 of DD 254 1999)

(Section 18 of DD 254 2017, 2018 and 2019)

Optional

No specific formatting required

EV. Client Authorization Required for Public Release of Contract Information

Optional

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

EW. Protected Health Information (PHI)

Optional

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

EX. Personally Identifiable Information (PII)

Optional

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

EY. Type of Government Credentials Issued

Optional

PROFILE – 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.
If left blank, defaults to None

Default Profile Descriptions: None, PIV

EZ. Training Requirements

Optional

PROFILE – 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.
If left blank, defaults to None

Default Profile Descriptions: None, Info Sec

FA. Corporate Security Remarks

Optional
No specific formatting required

FB. Field Office Remarks

Optional
No specific formatting required

 

Change Log

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]