06C25R0075 - SOW Attach 2 - Data File Layouts.pdf

PDF 757 KB Posted

Attached to
CBP Online Applicant Competency Assessment Service (COACA) and CBP Automated Testing Services (CATS) Federal contract opportunity
Solicitation number
70B06C25R00000075
Issued by
Department of Homeland Security Customs and Border Protection

About this file

Written by GovTribe AI ·

This document is a detailed data file layout provided by U.S. Customs and Border Protection (CBP) for the Online Applicant Competency Assessment Service (COACA) and CBP Automated Testing Services (CATS). The file specifies a comprehensive set of data fields for tracking candidate information, test scores, and performance metrics across multiple CBP job categories including Border Patrol, Agriculture Specialists, CBP Officers, Marine Interdiction Agents, Air Interdiction Agents, and Aviation Enforcement Agents.

The data layout includes fields for personal identifiers (name, ID number, work location), organizational levels, email contact, test dates, raw scores, percentile rankings, and specific competency evaluation index (CEI) scores for different job specialties. Each record is delimited by a pipe (|) character, with fields ranging from short text descriptions to integer score measurements. The document provides detailed specifications for how each field should be populated, including field types, sizes, and descriptions, which appears designed to standardize data collection and reporting for CBP's applicant assessment and testing processes.

View the file

Other files for this federal contract opportunity

Other files attached to CBP Online Applicant Competency Assessment Service (COACA) and CBP Automated Testing Services (CATS), newest first.
File Type Posted
Attachment 1 - 06C25R0075 Statement of Work R1.docx DOCX document
Attachment 3 - 06C25R0075 Requirements Traceability Matrix (RTM) R1.docx DOCX document
70B06C25R00000075 _ SF 1449 and RFP 70B06C25R00000075 R2.pdf PDF
Attachment 2 - 06C25R0075 Pricing Tables R1.xlsx XLSX spreadsheet
70B06C25R00000075 _ SF 1449 R2.pdf PDF
RFP 70B06C25R00000075 - Questions and Answers.pdf PDF
70B06C25R00000075 _ SF 1449 and RFP R1.pdf PDF
06C25R0075 - SOW Attach 3b - CBPO Zip Codes.pdf PDF
Attachment 1 - 06C25R0075 Statement of Work .docx DOCX document
06C25R0075 - SOW Attach 3a - BPA Zip Codes.pdf PDF
70B06C25R00000075 - SF 1449 and RFP.pdf PDF
Attachment 2 - 06C25R0075 Pricing Tables - Draft.xlsx XLSX spreadsheet
Attachment 3 - 06C25R0075 Requirements Traceability Matrix (RTM).doc DOC document
Attachment 6 - 06C25R0075 Past Performance Questionnaire.pdf PDF
06C25R0075 - SOW Attach 1 - Test Item Examples.pdf PDF
06C25R0075 - SOW Attach 3c - AMO Zip Codes.pdf PDF
06C25R0075 - SOW Attach 4 - Sample Source Report.pdf PDF
06C25R0075 - SOW Attach 5 - Sample Graphical Comparison.pdf PDF
Attachment 4 - 06C25R0075 Subcontracting Plan Outline.docx DOCX document
Attachment 5 - 06C25R0075 Technical Proposal Content Requirements.docx DOCX document
Show all 20

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

DATA FILE LAYOUT PROVIDED TO VENDOR BY CBP

NOTE : This entire list of fields represents a single record. Each field is delimited by |.

Name Type Size Description PackageID Short Text 9 Opening label (e.g., AMO19F, AMO19FL1, AMO19FL2, AMO19FR)

IDNumber Long Integer or Text 8 Candidate unique ID number

NameL Short Text 25 Last Name

NameF Short Text 25 First Name

NameM Short Text 25 Middle Initial

ZipWork Short Text 7 No +4 numbers; if a domestic zip code, only 5-digits

Work Country Short Text 25 2-digit ISO code score_correction Yes/No -1 = merely a correction (overwrites); 0 = brand new report (archives prior)

Org Level 3 Short Text 100 From All Employees dataset

Org Level 4 Short Text 100 From All Employees dataset

Org Level 5 Short Text 100 From All Employees dataset

Org Level 6 Short Text 100 From All Employees dataset

Org Level 7 Short Text 100 From All Employees dataset

Org Level 8 Short Text 100 From All Employees dataset

Email Short Text 75 Email address from cleaned application

GradeHi Short Text 2 High grade from cleaned application send_email Yes/No -1 = send the associated email; 0 = do not send the associated email

CEI_SBP Integer BP CEI score, SBP

CEI_WC Integer BP CEI score, WC

CEI_AC Integer BP CEI score, AC

CEI_PAC Integer BP CEI score, PAC

CEI_CPA Integer BP CEI score, CPA

CEI_AS1 Integer Ag Specialist CEI score, AS1

CEI_AS2 Integer Ag Specialist CEI score, AS2

CEI_ASA Integer Ag Specialist CEI score, ASA

CEI_ASP Integer Ag Specialist CEI score, ASP

CEI_CB1 Integer CBPO Officer CEI score, CB1

CEI_CB2 Integer CBPO Officer CEI score, CB2

CEI_CPM Integer CBPO Officer CEI score, CPM

CEI_CPD Integer CBPO Officer CEI score, CPD

BDateJK Date BP JK, date taken

BScoreJK Integer BP JK, raw score

BPossJK Integer BP JK, max raw score possible

BPcntJK Integer BP JK, percent correct (100*raw/possible, rounded to integer)

BNeedJK Short Text 3 BP JK, developmental need; “Yes” if % correct <66, “No” if % correct >=66

BDateCTS Date BP CTS, date taken

BScoreCTS Integer BP CTS, raw score

BPossCTS Integer BP CTS, max raw score possible

BPcntCTS Integer BP CTS, percent correct (100*raw/possible, rounded to integer)

DRAFT

BNeedCTS Short Text 3 BP CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

BPcntLS Integer BP CTS, Linking Statements, percent correct (rounded to integer)

BNeedLS Short Text 3 BP CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

BPcntLG Integer BP CTS, Linking Groups, percent correct (rounded to integer)

BNeedLG Short Text 3 BP CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

BPcntReas Integer BP CTS, Reasoning (Negatives), percent correct (rounded to integer)

BNeedReas Short Text 3 BP CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

BPcntAI Integer BP CTS, Avoiding Illogical Biases, percent correct (rounded to integer)

BNeedAI Short Text 3 BP CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

BDateMW Date BP MW, date taken

BScoreMW Integer BP MW, raw score

BPossMW Integer BP MW, max raw score possible

BPcntMW Integer BP MW, percent correct (100*raw/possible, rounded to integer)

BNeedMW Short Text 3 BP MW, developmental need; “Yes” if % correct <66, “No” if % correct >=66

BPcntSC Integer BP MW, Sentence Construction, percent correct (rounded to integer)

BNeedSC Short Text 3 BP MW, developmental need; “Yes” if % correct <66, “No” if % correct >=66

BPcntPC Integer BP MW, Paragraph Construction, percent correct (rounded to integer)

BNeedPC Short Text 3 BP MW, developmental need; “Yes” if % correct <66, “No” if % correct >=66

BDateIB Date BP IB, date taken

BScoreIB Integer BP IB, raw score

BPossIB Integer BP IB, max raw score possible

BPcntIB Integer BP IB, percent correct (100*raw/possible, rounded to integer)

BNeedIB Short Text 3 BP IB, developmental need; “Yes” if % correct <66, “No” if % correct >=66

CDateCTS Date CBPOAG CTS, date taken

CScoreCTS Integer CBPOAG CTS, raw score

CPossCTS Integer CBPOAG CTS, max raw score possible

CPtileCTS Integer CBPOAG CTS, Percentile

CPcntCTS Integer CBPOAG CTS, percent correct (100*raw/possible, rounded to integer)

CNeedCTS Short Text 3 CBPOAG CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

CPcntLS Integer CBPOAG CTS, Linking Statements, percent correct (rounded to integer)

CNeedLS Short Text 3 CBPOAG CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

CPcntLG Integer CBPOAG CTS, Linking Groups, percent correct (rounded to integer)

CNeedLG Short Text 3 CBPOAG CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

CPcntReas Integer CBPOAG CTS, Reasoning (Negatives), percent correct (rounded to integer)

CNeedReas Short Text 3 CBPOAG CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

CPcntAI Integer CBPOAG CTS, Avoiding Illogical Biases, percent correct (rounded to integer)

CNeedAI Short Text 3 CBPOAG CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

CDateMW Date CBPOAG MW, date taken

CScoreMW Integer CBPOAG MW, raw score

CPossMW Integer CBPOAG MW, max raw score possible

CPtileMW Integer CBPOAG MW, Percentile

CPcntMW Integer CBPOAG MW, percent correct (100*raw/possible, rounded to integer)

CNeedMW Short Text 3 CBPOAG MW, developmental need; “Yes” if % correct <66, “No” if % correct >=66

CPcntSC Integer CBPOAG MW, Sentence Construction, percent correct (rounded to integer)

CNeedSC Short Text 3 CBPOAG MW, developmental need; “Yes” if % correct <66, “No” if % correct >=66

CPcntPC Integer CBPOAG MW, Paragraph Construction, percent correct (rounded to integer)

CNeedPC Short Text 3 CBPOAG MW, developmental need; “Yes” if % correct <66, “No” if % correct >=66

CDateIB Date CBPOAG IB, date taken

CScoreIB Integer CBPOAG IB, raw score

CPossIB Integer CBPOAG IB, max raw score possible

CPtileIB Integer CBPOAG IB, Percentile

CPcntIB Integer CBPOAG IB, percent correct (100*raw/possible, rounded to integer)

CNeedIB Short Text 3 CBPOAG IB, developmental need; “Yes” if % correct <66, “No” if % correct >=66

SDateJK Date Not currently used

SScoreJK Integer Not currently used

SPossJK Integer Not currently used

SPtileJK Integer Not currently used

SPcntJK Integer Not currently used

SNeedJK Short Text 3 Not currently used

SPcntFI Integer Not currently used

SNeedFI Short Text 3 Not currently used

SPcntIS Integer Not currently used

SNeedIS Short Text 3 Not currently used

SPcntGCI Integer Not currently used

SNeedGCI Short Text 3 Not currently used

SPcntSPS Integer Not currently used

SNeedSPS Short Text 3 Not currently used

SPcntNSI Integer Not currently used

SNeedNSI Short Text 3 Not currently used

SDateCTS Date Not currently used

SScoreCTS Integer Not currently used

SPossCTS Integer Not currently used

SPtileCTS Integer Not currently used

SPcntCTS Integer Not currently used

SNeedCTS Short Text 3 Not currently used

SPcntLS Integer Not currently used

SNeedLS Short Text 3 Not currently used

SPcntLG Integer Not currently used

SNeedLG Short Text 3 Not currently used

SPcntReas Integer Not currently used

SNeedReas Short Text 3 Not currently used

SPcntAI Integer Not currently used

SNeedAI Short Text 3 Not currently used

SDateMW Date Not currently used

SScoreMW Integer Not currently used

SPossMW Integer Not currently used

SPtileMW Integer Not currently used

SPcntMW Integer Not currently used

SNeedMW Short Text 3 Not currently used

SPcntSC Integer Not currently used

SNeedSC Short Text 3 Not currently used

SPcntPC Integer Not currently used

SNeedPC Short Text 3 Not currently used

SDateIB Date Not currently used

SScoreIB Integer Not currently used

SPossIB Integer Not currently used

SPtileIB Integer Not currently used

SPcntIB Integer Not currently used

SNeedIB Short Text 3 Not currently used

SDateSI Date Not currently used

SScoreSI Integer Not currently used

SPossSI Integer Not currently used

SPtileSI Integer Not currently used

SScoreLO Integer Not currently used

SPossLO Integer Not currently used

SScoreTB Integer Not currently used

SPossTB Integer Not currently used

SScorePRM Integer Not currently used

SPossPRM Integer Not currently used

SScoreDMPS Integer Not currently used

SPossDMPS Integer Not currently used

SScoreOC Integer Not currently used

SPossOC Integer Not currently used

SScoreIS Integer Not currently used

SPossIS Integer Not currently used

ScoreSBP Integer BP Total Score, SBP

PcntSBP Integer BP Total Score Percentile, SBP

ScoreWC Integer BP Total Score, WC

PcntWC Integer BP Total Score Percentile, WC

ScorePAC Integer BP Total Score, PAC

PcntPAC Integer BP Total Score Percentile, PAC

ScoreCPA Integer BP Total Score, CPA

PcntCPA Integer BP Total Score Percentile, CPA

ScoreAS1 Integer Ag Specialist Total Score, AS1

PcntAS1 Integer Ag Specialist Total Score Percentile, AS1

ScoreAS2 Integer Ag Specialist Total Score, AS2

PcntAS2 Integer Ag Specialist Total Score Percentile, AS2

ScoreASA Integer Ag Specialist Total Score, ASA

PcntASA Integer Ag Specialist Total Score, Percentile ASA

ScoreASP Integer Ag Specialist Total Score, ASP

PcntASP Integer Ag Specialist Total Score, Percentile ASP

ScoreCB1 Integer CBP Officer Total Score, CB1

PcntCB1 Integer CBP Officer Total Score Percentile, CB1

ScoreCB2 Integer CBP Officer Total Score, CB2

PcntCB2 Integer CBP Officer Total Score Percentile, CB2

ScoreCPM Integer CBP Officer Total Score, CPM

PcntCPM Integer CBP Officer Total Score Percentile, CPM

ScoreCPD Integer CBP Officer Total Score, CPD

PcntCPD Integer CBP Officer Total Score Percentile, CPD

ScoreSA Integer Not currently used

PcntSA Integer Not currently used

EffDateBP Date Report Effective Date, BP

EffDateAS Date Report Effective Date, Ag Specialist

EffDateCBPO Date Report Effective Date, CBP Officer

EffDateSA Date Not currently used

CEI_MIA1 Integer Marine Interdiction Agent CEI score, MI1

CEI_MIA2 Integer Marine Interdiction Agent CEI score, MI2

CEI_AIA Integer Air Interdiction Agent CEI score, AIA

CEI_AIO Integer Aviation Enforcement Agent CEI score, AIO

ADateCTS Date AMO CTS, date taken

AScoreCTS Integer AMO CTS, raw score

APossCTS Integer AMO CTS, max raw score possible

APcntCTS Integer AMO CTS, percent correct (100*raw/possible, rounded to integer)

ANeedCTS Short Text 3 AMO CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

APcntLS Integer AMO CTS, Linking Statements, percent correct (rounded to integer)

ANeedLS Short Text 3 AMO CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

APcntLG Integer AMO CTS, Linking Groups, percent correct (rounded to integer)

ANeedLG Short Text 3 AMO CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

APcntReas Integer AMO CTS, Reasoning (Negatives), percent correct (rounded to integer)

ANeedReas Short Text 3 AMO CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

APcntAI Integer AMO CTS, Avoiding Illogical Biases, percent correct (rounded to integer)

ANeedAI Short Text 3 AMO CTS, developmental need; “Yes” if % correct <66, “No” if % correct >=66

ADateMW Date Not currently used

AScoreMW Integer Not currently used

APossMW Integer Not currently used

APcntMW Integer Not currently used

ANeedMW Short Text 3 Not currently used

APcntSC Integer Not currently used

ANeedSC Short Text 3 Not currently used

APcntPC Integer Not currently used

ANeedPC Short Text 3 Not currently used

ScoreM1 Integer Marine Interdiction Agent Total Score, MI1

PcntM1 Integer Marine Interdiction Agent Total Score Percentile, MI1

ScoreM2 Integer Marine Interdiction Agent Total Score, MI2

PcntM2 Integer Marine Interdiction Agent Total Score Percentile, MI2

ScoreAIA Integer Air Interdiction Agent Total Score, AIA

PcntAIA Integer Air Interdiction Agent Total Score Percentile, AIA

ScoreAIO Integer Aviation Enforcement Agent Total Score, AIO

PcntAIO Integer Aviation Enforcement Agent Total Score Percentile, AIO

EffDateMIA Date Report Effective Date, Marine Interdiction Agent

EffDateAIA Date Report Effective Date, Air Interdiction Agent

EffDateAIO Date Report Effective Date, Aviation Enforcement Agent

ADateSI Date Not currently used

AScoreSI Integer Not currently used

AScoreFlex Integer Not currently used

AScoreLO Integer Not currently used

AScoreMC Integer Not currently used

AScoreTeam Integer Not currently used

AScoreSM Integer Not currently used

AScoreDM Integer Not currently used

AScoreIN Integer Not currently used

AScoreOC Integer Not currently used

ScoreIEA1 Integer Not currently used

PcntIEA1 Integer Not currently used

ScoreIEA2 Integer Not currently used

PcntIEA2 Integer Not currently used

ScoreDO1 Integer Not currently used

PcntDO1 Integer Not currently used

ScoreDO2 Integer Not currently used

PcntDO2 Integer Not currently used

ScoreDO3 Integer Not currently used

PcntDO3 Integer Not currently used

MIADateCEI Date CEI Effective Date, MIA

AIADateCEI Date CEI Effective Date, AIA

AIODateCEI Date CEI Effective Date, AIO

ADateCEI Date CEI Effective Date, Ag Specialist

BDateCEI Date CEI Effective Date, Border Patrol

CDateCEI Date CEI Effective Date, CBP Officer

File details come from the government source that posted it. Updated .