Versions Supported

  • AC v4.05


Templates Supported

  • Template_Contracts_2021_March.xlsx



Column and Title

Description

A. Contract Number

Required

Must be Unique

No specific formatting required.

Maximum Character Length: 60

If blank, upload fails.

B. Contract Name

Required

No specific formatting required.

Maximum Character Length: 60

If blank, upload fails.

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

If blank, upload fails.

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: MM-DD-YYYY

G. PoP End Date

Required

Format: MM-DD-YYYY

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

Required

Allowed values are Yes, No or N/A

M. Poly Type Required

Required

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.

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

N. Incidents Must Be Reported

Required

Allowed values are Yes, No or N/A

O. Lawful/Legal Permanent Resident Allowed

Required

Allowed values are Yes, No or N/A

P. Authorized Alien/Work Visa

Required

Allowed values are Yes, No or N/A

Q. US Citizenship

Required

Allowed values are Yes, No or 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 N (for No) or Y (for Yes)

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: MM-DD-YYYY

AF. Closeout Date

Optional

Format: MM-DD-YYYY

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: MM-DD-YYYY

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 N (for No) or Y (for Yes)

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

Date Field

Format: MM-DD-YYYY

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

BM. User Defined Date Field 2

Optional

Date Field

Format: MM-DD-YYYY

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

BN. User Defined Date Field 3

Optional

Date Field

Format: MM-DD-YYYY

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

BO. User Defined Date Field 4

Optional

Date Field

Format: MM-DD-YYYY

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

BP. User Defined Date Field 5

Optional

Date Field

Format: MM-DD-YYYY

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

BQ. User Defined Date Field 6

Optional

Date Field

Format: MM-DD-YYYY

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

BR. User Defined Date Field 7

Optional

Date Field

Format: MM-DD-YYYY

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

BS. User Defined Date Field 8

Optional

Date Field

Format: MM-DD-YYYY

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

BT. User Defined Date Field 9

Optional

Date Field

Format: MM-DD-YYYY

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

BU. User Defined Date Field 10

Optional

Date Field

Format: MM-DD-YYYY

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 Y (for Yes) or N (for No)

CQ. b. Restricted Area

(Section 10 of DD 254)

Optional

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

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

(Section 10 of DD 254)

Optional

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

CS. d. Formerly Restricted Data

(Section 10 of DD 254)

Optional

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

CT. 1. Sensitive Compartment Information (SCI)

(Section 10 of DD 254)

Optional

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

CU. 2. Non-SCI

(Section 10 of DD 254)

Optional

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

CV. f. Special Access Program (SAP) Information

(Section 10 of DD 254)

Optional

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

CW. g. North Atlantic Treaty Organization

(Section 10 of DD 254)

Optional

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

CX. h. Foreign Government Information

(Section 10 of DD 254)

Optional

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

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

(Section 10 of DD 254)

Optional

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

This is applicable to DD254 2017, 2018 and 2019

CZ. i. Limited Dissemination Information

(Section 10 of DD 254)

Optional

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

This is applicable to DD254 1999 only

DA. j. Controlled Unclassified Information

(Section 10 of DD 254)

Optional

Allowed Values are Y (for Yes) or N (for 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 Y (for Yes) or N (for No)

This is applicable to DD254 1999 only

DC. k. Other

(Section 10 of DD 254)

Optional

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

DD. l. AIS

(Section 10 of DD 254)

Optional

Allowed Values are Y (for Yes) or N (for 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 Y (for Yes) or N (for No)

DF. b. Receive and Store Classified Documents Only

(Section 11 of DD 254)

Optional

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

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

(Section 11 of DD 254)

Optional

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

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

(Section 11 of DD 254)

Optional

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

DI. e. Perform Services Only

(Section 11 of DD 254)

Optional

Allowed Values are Y (for Yes) or N (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)

Optional

Allowed Values are Y (for Yes) or N (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)

Optional

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

DL. h. Require a COMSEC Account

(Section 11 of DD 254)

Optional

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

DM. i. Have a TEMPEST Requirement

(Section 11 of DD 254)

Optional

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

DN. j. Have Operations Security (OPSEC) Requirements

(Section 11 of DD 254)

Optional

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

DO. k. Be Authorized to Use Defense Courier Service

(Section 11 of DD 254)

Optional

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

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

(Section 11 of DD 254)

Optional

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

This is applicable to DD254 2017, 2018 and 2019

DQ. m. Other

(Section 11 of DD 254)

Optional

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

DR. Direct

(Section 12 of DD 254)

Optional

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

DS. Through

(Section 12 of DD 254)

Optional

Allowed Values are Y (for Yes) or N (for 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 Y (for Yes) or N (for 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 Y (for Yes) or N (for 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

No specific formatting required

EO. Contractor

(Section 17 of DD 254 1999)

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

Optional

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

EP. Subcontractor

(Section 17 of DD 254 1999)

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

Optional

Allowed Values are Y (for Yes) or N (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)

Optional

Allowed Values are Y (for Yes) or N (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)

Optional

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

ES. Administrative Contracting Office

(Section 17 of DD 254 1999)

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

Optional

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

ET. Others as necessary

(Section 17 of DD 254 1999)

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

Optional

Allowed Values are Y (for Yes) or N (for 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 Y (for Yes) or N (for No)

EW. Protected Health Information (PHI)

Optional

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

EX. Personally Identifiable Information (PII)

Optional

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

EY. Type of Government Credentials Issued

Optional

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

EZ. Training Requirements

Optional

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

FA. Corporate Security Remarks

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.

Default Profile Descriptions: None, PIV

FB. Field Office Remarks

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.

Default Profile Descriptions: None, Info Sec