Appendix_T-_Functional_Requirement.xlsx

XLSX spreadsheet 111 KB Posted

Attached to
Identity Management System
Solicitation number
2026-RFP-0026
Issued by
Sacramento County, San Francisco City, California

About this file

This is a functional requirements and capabilities spreadsheet for Sacramento International Airport's (SMF) Identity Management System (IDMS) procurement, prepared by Sacramento County Contract & Purchasing Services Division and the Sacramento County Department of Airports. The IDMS will automate badge application processing, renewal, modification, and revocation for approximately 5,700+ airport ID badges and credentials managed by 180+ Authorized Signatories, replacing current manual, paper-based processes. The system must support regulatory compliance with TSA requirements under 49 CFR Part 1542, including application submission, authorized signatory portal management, audit capabilities, badge production, company enrollment, document management, email notifications, financial management, training, violations tracking, and comprehensive reporting. The document contains 123 mandatory functional requirements (R-001 through R-123) and 125 functional capabilities (FC-001 through FC-125) requiring vendor responses indicating whether proposed solutions meet or do not meet specified requirements. The pre-bid meeting is scheduled for May 5, 2026, at 2:00 PM via Microsoft Teams; questions are due by May 26, 2026, at 4:00 PM; proposals must be submitted electronically through the SacCountyEbids portal by June 23, 2026, at 4:00 PM Pacific Standard Time; and contract award is anticipated for August 11, 2026. The contract term is five years with potential vendor demonstrations required from shortlisted contractors prior to final selection.

The solution must integrate with Sacramento County's existing enterprise infrastructure, including Microsoft Active Directory, Oracle and SQL Server databases, VMware ESX virtualization, NetApp SAN storage, Cisco networking, Palo Alto firewalls, and F5 load balancers. Required integrations include Velocity Physical Access Control System (PACS), Telos Designated Aviation Channeling (DAC) system, livescan fingerprint systems, computer-based training platforms, and DL/Passport credential verification systems. Cloud-based solutions must achieve FedRAMP or StateRAMP Ready Status within 90 days of agreement execution and full authorization within 12 months; on-premises solutions must implement CrowdStrike Falcon, Tanium, and Splunk Universal Forwarder security tools, with the County requiring data storage in U.S.-based data centers. No specific budget or award value is disclosed; however, the comprehensive five-year support requirement and substantial implementation scope indicate significant procurement value. Contractors must demonstrate five years of continuous IDMS or Physical Access Control System operation, technical application of 49 CFR Parts 1540 and 1542, TSA Security Directives, and California privacy laws. The RFP incorporates FAA Non-AIP Contract Provisions requiring federal civil rights compliance and domestic preference for U.S.-produced goods and materials; no incumbent vendor is identified, and no set-asides for disadvantaged enterprises are included.

View the file

Other files

File Type Posted
Identity_Management_System_(Addendum_#3_Revision).pdf PDF
Identity_Management_System_(Addendum_#2_Revision).pdf PDF
Identity_Management_System.pdf PDF
Appendix_R_-_Minimum_Qualifications.docx DOCX document
Appendix_T-_Functional_Requirement.xlsx XLSX spreadsheet
Appendix_W_-_Project_Management_.docx DOCX document
Appendix_Z4_-_Security-Terms_and_Conditions.docx DOCX document
Exhibit_1_-_FAA_Contract_Provisions.pdf PDF
Appendix_H_-_Customer_References_.docx DOCX document
Appendix_I-_Pricing.xlsx XLSX spreadsheet
STATERAMP_System_Security_Plan_Template_(1).docx DOCX document
APPENDIX_Y_PROPOSAL_PACKAGE_CHECKLIST_(1).docx DOCX document
Appendix_I-_Pricing.xlsx XLSX spreadsheet
Appendix_S_-_Organization_and_Experience.docx DOCX document
Appendix_V_-_Technical_Requirements.docx DOCX document
Proposal_Package_Instructions_(5).docx DOCX document
Appendix_Z3_-_COS_SEC_REQ.docx DOCX document
Appendix_V_-_Technical_Requirements.docx DOCX document
Appendix_Z4_-_Security-Terms_and_Conditions.docx DOCX document
Proposal_Package_Instructions_(5).docx DOCX document
Appendix_H_-_Customer_References_.docx DOCX document
Appendix_U_-_Narrative_Response.docx DOCX document
Appendix_X_-_Support_and_Maintenance.docx DOCX document
STATERAMP_System_Security_Plan_Template_(1).docx DOCX document
APPENDIX_Y_PROPOSAL_PACKAGE_CHECKLIST_(1).docx DOCX document
Appendix_R_-_Minimum_Qualifications.docx DOCX document
Appendix_S_-_Organization_and_Experience.docx DOCX document
Appendix_U_-_Narrative_Response.docx DOCX document
Appendix_W_-_Project_Management_.docx DOCX document
Appendix_X_-_Support_and_Maintenance.docx DOCX document
Appendix_Z3_-_COS_SEC_REQ.docx DOCX document
Exhibit_1_-_FAA_Contract_Provisions.pdf PDF
Show all 32

On GovTribe

Work with this file

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

Text version

Functional Requirements

Functional RequirementsVENDOR Response
IDCategoryFunctional AreaRequirement DescriptionIdentify the requirement meets asComments
Product Feature (C ) or Non-Compliant
(NC)
R-001MandatoryApplication ProcessProvide capability for the applicant to electronically submit badge applications, including Disqualifying Crimes and all other TSA required certifications and the airports Badge holder rules to their Authorized Signatory.
R-002MandatoryApplication ProcessThe IDMS shall have capability to clearly identify the type of application such as new badge application, renewal badge application, badge change (for adding or removing privileges e.g. escort, driving privilege), replacement badge application (name change or lost, stolen or mutilated).
R-003MandatoryApplication ProcessThe IDMS shall allow the Trusted Agent to review and modify as necessary all the information submitted by the Authorized Signatory or the applicant.
R-004MandatoryApplication ProcessThe IDMS shall alert the Trusted Agent if the new badge applicant already exists and allow the Trusted Agent to review the duplicate record and merge or process individually.
R-005MandatoryAS PortalAuthorized Signatory Portal must be accessible via the most commonly used Web Browsers to include Chrome, Edge, Bing and Safari.
R-006MandatoryAuditThe IDMS Audit capability will meet all the TSA regulatory requirements per the National Amendments.
R-007MandatoryAuditAudit should allow selection of records for Audit based on company, specific individuals and badge type.
R-008MandatoryAuditWhen completing the badge or key audits the Authorized Signatory must not be able to select all records in one transaction.
R-009MandatoryAuditIDMS shall add false names to company audits that will be randomly added and different in each company. The number or percentage of names added to an audit should be set/administered each audit by the Security Access and Badging Office,
R-010MandatoryAuthorized SignatoryIDMS must automatically deactivate an Authorized Signatory from the AS Portal if the Authorized Signatory fails to maintain up to date Authorized Signatory training, an active badge and maintains all required security clearances (STA/CHRC/Rap Back when applicable).
R-011MandatoryAuthorized SignatoryIDMS must assign each Authorized Signer a unique user account and password upon completion of the approval process, required training and badge issuance. This user account will be used for submission of employee badge applications and all other business activities performed using the Authorized Signatory Portal.
R-012MandatoryAuthorized SignatoryIDMS shall provide and describe mechanisms to incorporate multi-factor authentication for the Authorizing Signatory Portal. The IDMS shall have the capability to implement OTP / authentication codes via text or email.
R-013MandatoryAuthorized SignatorySMF Trusted Agent shall be the first Authorized Signatory for each new company being onboarded.
R-014MandatoryAuthorized SignatoryMust allow the Authorized Signatories to submit applications for new and renew badges, request badge type change (Sterile/SIDA) submit request for adding/removing badge privilege (e.g. escort and driving) and the ability to indicate that a badge is lost/stolen or the employee is terminated.
R-015MandatoryAuthorized SignatoryWill allow an Authorized Signatory to renew badges 60 days before the badge expires.
R-016MandatoryAuthorized SignatoryEnsure Authorized Signatories cannot see notes that the Trusted Agent's entered.
R-017MandatoryAuthorized SignatoryThe IDMS shall allow Authorized Signatories to modify certain employee information while restricting changes to Date of Birth (DOB), SSN, Birth Country and other fields deemed to be critical to the STA process or SMF.
R-018MandatoryAuthorized SignatoryThe Authorized Signatories will see only those companies and badge holders, they are responsible for.
R-019MandatoryAuthorized
SignatoryRequire password reset at initial log-in to Authorized Signatory Portal.
R-020MandatoryBadge PaymentsAllow payment methods to be defined at individual company levels (Billing, credit card or no billing).
R-021MandatoryBadge PaymentsProvide the capability to manage and track the fees associated with badges, keys, violations and other items issued in the Security Access Control and badge Office. SMF must be able to update/change badge fees without needing Contractor’s support team assistance.
R-022MandatoryBadge ProductionIDMS shall permit system administrators to change the layout and design of Airport ID Badge templates.
R-023MandatoryBadge ProductionAutomatically calculate and default the maximum expiration date for each new, renewed or reprinted badge based on the airport’s requirements.
R-024MandatoryBadge ProductionThe IDMS shall clearly indicate on the UI if the badge was returned, badge returned date, badge printed date, badge printed date, badge pick-up date.
R-025MandatoryBadge ProductionWhen the current date passes the expiration date on a badge, automatically update the badge status and deactivate the badge in the PACS.
R-026MandatoryBadge ProductionPrevent printing a badge if any of the requirements such as background checks, training or documents are not completed in the IDMS.
R-027MandatoryBadge ProductionIDMS must support SEOS prox, ISO/IEC 7816, ISO/IEC 14443, ISO/IEC 15693 and ISO/IEC 7501 smart-card technologies and must also support the Federal Information Processing Standard 201 (FIPS-201).
R-028MandatoryBadge ProductionAllow creation of new badges as replacements for unaccounted (e.g. lost, stolen) badges by copying previous badge details, badge expiration date and establishing a new badge number.
R-029MandatoryBadge ProductionSMF requires that the previous badge number be used for renewal badges (unless reported lost/stolen or is unaccounted for).
R-030MandatoryBadge ProductionPrint a receipt and send notification to the badge holder and / or Authorized Signatory as proof the badge was returned.
R-031MandatoryBadge ReceiptsIssue Receipt upon Badge Return and provide ability to email the receipt to the Authorized Signatory or any other email address entered manually.
R-032MandatoryCompanyIDMS shall provide ability to capture company names such as business legal names, doing business as, abbreviated name to be printed on the badge.
R-033MandatoryCompanyIDMS shall provide capability to configure at company and division level the ID requirements (certain government employees can provide one Form I-9 document), access levels/clearance codes, payments (monthly billing, pay-as-you-go, fee waived), s (badge fees, other fees), badge limits, designation limits, security check exemptions (CHRC, Rap Back and /or STA).
R-034MandatoryCompanyIDMS shall provide the capability to scan and upload documents related to company enrollment. For example, company authorization letters and contract or sponsorship documents.
R-035MandatoryCompanyThe IDMS shall allow suspension of a company, but existing active badges will not be automatically de-activated. However, when a company is suspended no new badges can be issued/printed until the company is active again.
R-036MandatoryCompanyProvide capability to set maximum number of active badges (percentage of numeric) for specific badge type or badge privilege for a company. (e.g. 25% concessionaire rule or limiting escort privileges.). Restrict badge printing if the limit is reached.
R-037MandatoryCompanyProvide capability for SMF to configure or modify default access levels / clearance codes for an approved company.
R-038MandatoryCompanyThe IDMS should provide capability for SMF to perform bulk / volume tasks such as de-activation of badges, change access levels/clearance codes by badge type or company or divisions.
R-039MandatoryCompanyThe IDMS shall provide functionality to allow mergers of companies (e.g. legal name changes and badge printed names) including providing report of all badge holders impacted.
R-040MandatoryDashboardThe IDMS shall provide immediate notification to the system administrator, Security Access Control and badge Office Manager if the connection to the DACS is lost.
R-041MandatoryDashboardProvide on dashboard or custom queue STA and CHRC results that are pending.
R-042MandatoryData Migration - Data Analysis, Reconciliation and MigrationsA data mapping exercise must be conducted to map existing fields in PACS and determine fields must be maintained in the IDMS.
R-043MandatoryData Migration - Data Analysis, Reconciliation and MigrationsData cleansing must be conducted prior to implementation for remediation of data issues. A review of existing badges must be completed for badge color

and access consistency, data accuracy, missing data fields, and compliance. Manual and system automated cleansing may be used.

R-044 Mandatory Data Migration - Data Analysis, Reconciliation and Migrations The contractor shall perform data analysis and provide reconciliation reports across all data sources integrated in the IDMS including but not limited to PACS, DAC and Finance system.

R-045 Mandatory Data Migration - Data Analysis, Reconciliation and Migrations The contractor shall provide reconciliation reports clearly identifying the data mismatches, duplicates records, missing and inconsistent data fields (DOB, SSN, etc.) and action plan for normalizing the data. The recommendations can include automated scripts to fix the data by the contractor, manual clean up missing information by Airport or other 3rd party system updates.

R-046MandatoryData Migration - Data Analysis, Reconciliation and MigrationsThe new Unique Person ID number field must be generated for all existing employees during the data import to IDMS.
R-047MandatoryData Migration - Data Analysis, Reconciliation and MigrationsThe Unique Personal Identifier must be assigned to each existing badge

holder during migration in IDMS and similarly provide plan to update other systems PACS, DAC etc.

R-048MandatoryData Migration - Data Analysis, Reconciliation and MigrationsThe contractor shall perform data analysis and provide reconciliation reports in progressively and iterative method.
R-049MandatoryData Migration - Data Analysis, Reconciliation and MigrationsIdentify all data to be migrated into the IDMS in a transition plan, which shall include a data migration validation. The contract shall perform data

migrations during every system acceptance testing iteration.

R-050MandatoryData Migration - Data Analysis, Reconciliation and MigrationsProposer shall include a Roll back plan for all data and processes in the event the go-live event does not execute as planned
R-052MandatoryDocument ManagementIDMS must accommodate for all identification types shown on the Form I-9 Acceptable Documents List (List A, B & C) and ensure that the applicant’s scanned documents are the correct combination.
R-053MandatoryDocument ManagementIDMS will allow for SMF identified organizations to only provide one identity document (for example TSA and LEO’s)
R-054MandatoryDocument ManagementProvide ability to restrict viewing of scan and stored documents (e.g. Rap sheets) and mark private based on user roles and permission levels.
R-055MandatoryDocument ManagementProvide ability to scan, validate, and store Identification documents provided by applicants. Data retrieved from the documents should have the ability to auto-populate fields, reducing keying errors and saving time.
R-056MandatoryDocument ManagementWhen documents are scanned the IDMS shall have the ability to alert the operator of mismatched data elements (e.g. name on document does not match demographic data previously captured for the applicant).
R-057MandatoryDocument ManagementProvide the ability to archive badge records automatically on preset schedule following SMF data retention policies.
R-058Mandatorye-BadgeIDMS will support the automation of e-Badge and provide a CBP User Role which will allow CBP to approve Seals in IDMS.
R-059MandatoryEmail NotificationsIDMS shall allow system administrators to add / modify wording in the email templates.
R-060MandatoryEmail NotificationsProvide capability to send various notifications with reminders and escalations to the Authorized Signatory.
R-061MandatoryEmail notificationsThe IDMS shall have the capability to send email notifications to the Authorized Signatories for various activities as defined by SMF.
R-062MandatoryGeneralThe IDMS must meet the badging procedures and regulatory requirements as outlined in the Code of Federal Regulations (CFR) Title 49 Part 1542, the SMF ASP requirements and all other security regulations (including National Amendments and Security Directives).
R-063MandatoryGeneralList the 3rd party licenses provided by the vendor, unit price, quantities, and licenses that the Airport needs to provide for IDMS.
R-064MandatoryGeneralProvide the capability to mask all or specific Personal Identifiable Information (PII) (e.g. SSN) and non-PII (e.g. PIN) data fields for display after initial input. The masking will be based on business rules and allow the airport to modify PII fields. The UI will clearly indicate if the data is entered or not entered or missing.
R-065MandatoryGeneralProvide invalid or non-conforming entries (E.g. red color) on the screen and prevent invalid or incomplete submissions.
R-066MandatoryGeneralProvide ability to make comments private/ secured based on user roles
R-067MandatoryGeneralAllow Trusted Agents or other airport users to create “Hot Notes” that immediately display when the person record is queried. Allow modification or deletion of the “Hot Note” by the person who created it or a supervisor.
R-068MandatoryGeneralUser roles should be configurable by the SMF System Administrator and not require users to have multiple log ins/ user roles to be able to complete all their job duties.
R-069MandatoryHardware/ Software IntegrationsPhysical Access Control System - Velocity-(existing system)
R-070MandatoryHardware/ Software IntegrationsLivescan Fingerprint system (Cross Match)
R-071MandatoryHardware/ Software IntegrationsTELOS DAC - for execution of STAs, CHRCs, Rap Back and e-Badge; bi-directional, real time with demographic data
R-072MandatoryHardware/ Software IntegrationsComputer based training (CBT) platform (SSI)
R-073MandatoryHardware/ Software IntegrationsCustoms and Border Protection (eBadge Program)
R-074MandatoryHardware/ Software IntegrationsDL/Passport credential verification system- to import information extracted from ID documents
R-075MandatoryHardware/ Software IntegrationsWatch List and Stop List issuance and distribution
R-076MandatoryHardware/ Software IntegrationsBadge Printing using existing badge printers’ system or vendor suggested printer use
R-077MandatoryHardware/ Software IntegrationsTouchscreen (if needed with IDMS product)
R-078MandatoryHardware/ Software IntegrationsMulti-page high speed document scanner
R-079MandatoryHardware/ Software IntegrationsExternal badge# reader and transmit badge number to IDMS
R-080MandatoryHardware/ Software IntegrationsAirport Email system (Outlook, Office 365, etc.)
R-081MandatoryHardware/ Software IntegrationsAirport's Active Directory for single sign-on for Airport's internal users (non-AS and non-Applicants)
R-082MandatoryIntegration DACSThe IDMS shall have capability to provide an automated method to submit the CHRC/Rap Back and STA requests via Telos. Rap Back updates and cancelations must be automated following TSA regulations and completed within the required timelines. STA results should not be able to be modified by the SMF team (only TSA).
R-083MandatoryIntegration DACSThe IDMS shall have capability to integrate with Telos and submit the data for STA, CHRC and Rap Back.
R-084MandatoryIntegration DACSAutomatically retrieve results from the DAC and update / populate matched STA results to the existing badge holder or applicant database.
R-085MandatoryIntegration DACSThe IDMS shall have the capability to provide an automated method to enroll badge holders in the Rap Back program upon submission of fingerprint to DACS and not wait for badge issuance.
R-086MandatoryIntegration DACSThe IDMS shall provide capability to electronically submit the identity documents to the DAC for both new and renewal badge applications.
R-087MandatoryIntegration DACSProvide the functionality to limit the review of background check results to authorized personnel.
R-088MandatoryIntegration FingerprintLivescan Fingerprint system (existing system -Cross Match)
R-089MandatoryIntegration PACSWhen a badge is marked as lost or stolen, the badge must immediately be deactivated in IDMS and the PACS.
R-090MandatoryIntegration PACSProvide ability to display doors / gates access that is associated with specific Clearance Codes.
R-091MandatoryIntegration PACSIDMS will provide a means to define and create templates or other methods of setting default clearance code / groups for employees of a company based on variables such as company name, company type, badge type, privileges, job title, department/division.
R-092MandatoryIntegration PACSProvide capability to auto assign clearance codes at a minimum based on job title, company name, company type, badge type. Allow manual override of the clearance codes (adding or deleting) by the Trusted Agent.
R-093MandatoryIntegration PACSPhysical Access Control System -Hirsch Velocity
R-094MandatoryIntegrations OtherAirport's Active Directory for single sign-on for Airport's internal users (non-AS and non-Applicants)
R-095MandatoryRecord ManagementWhen an Authorized Signatory or badge holder reports a badge as lost or stolen, the badge must immediately be deactivated in the PACS.
R-096MandatoryReportsGenerate reports that can be exported in multiple formats (at a minimum

.csv, .pdf and .xlsx formats).

R-097MandatoryReportsProvide SMF pre-defined reports, allowing the user to select or specify the grouping and / or sorting criteria.
R-098MandatorySecurity RequirementsIntegration between IDMS on secure Airport network and systems connected

via web services to external network (Authorized Signatory Portal, Applicant Portal, CBT, DAC, etc.) must be via secured protocol.

R-099MandatorySecurity RequirementsHave the ability to encrypt sensitive and personally identifiable information at rest and in transit for internal as well as external users (AS and Applicant).
R-100MandatorySecurity RequirementsThe data should be encrypted using Transparent Data Encryption (TDE), when the selected Proposer's application database contains Personal
R-101MandatorySecurity RequirementsProvide the capability to mask all or specific Personal Identifiable Information (PII) (e.g. SSN) and non-PII (e.g. PIN) data fields for display after initial input. The masking will be based on business rules and allow the Airport to

modify PII fields. The UI will clearly indicate if the data is missing.

R-102MandatorySecurity RequirementsInterface to manage all secure user logins Trusted Agents, Authorized Signatories.
R-103MandatorySecurity RequirementsShall have capability to enforce password policy at a minimum follow the NIST Special Publication 800-63-3: Digital Authentication Guidelines:

Disallow use of vendor supplied password defaults for system passwords Prevent passwords that are derivatives of the username Enforce password requirements of > = 8 characters and contains characters from 4 of the following 4 categories: Uppercase alphabetic (i.e., A- Z), Lowercase alphabetic (i.e., a-z), - Numeric (i.e., 0-9), Special characters (e.g.,. ! %@*#^ () _+|~) Require user to change password after first login Require user to reset password after a set period (90 days or Airport configurable)

R-104MandatorySecurity RequirementsSystem provides automated means for user password resets with authentication
R-105MandatorySecurity RequirementsTimes out IDMS web or client sessions according system administrator- configured period of idle time no longer than 15 minutes. The re-login should open the same screen/ page where auto logout triggered. IDMS mist saves

work prior to auto time-out.

R-106MandatorySecurity RequirementsLimit browser-based modules to accept only HTTPS connections for authentication purposes
R-107MandatorySecurity RequirementsUndo/rollback feature that reverts badge back to the prior state and logs it. For example, a badge is accidentally terminated, and the user can revert back to the prior state. Feature is controlled by user access and all rollbacks are

logged R-108 Mandatory Security Requirements Provide system security that is role-based allowing for update or read-only access to specific functions and obfuscation of defined data elements (i.e. SSN not visible or redacted on the screen for all users assigned to a specific role).

R-109MandatorySecurity RequirementsProvide method(s) for the System Administrator to view and maintain user profiles such as: add new users, modify and delete user profiles.
R-110MandatorySecurity RequirementsProvide details for cyber security based on NIS 800-171 and cyber security

framework, including not limited to penetration testing, proprietary or 3rd- party, conducted by the vendor

R-111MandatorySecurity RequirementsProvide details of a data breach Recovery Plan, including liability matrix
R-112Nice to HaveSystem AuditAutomatic audit trail logging and generate report of all data sent to integrated systems (PACS, DAC, CBT etc.), web calls, acknowledgement received from

the integrated systems, status of messages - success/ fail, error coding of failure.

R-113MandatorySystem AuditIDMS shall provide system integration audit report with error codes and actionable information to fix error.
R-114MandatorySystem AuditThe system should have capability to log and generate report for data updated by any user - table, field, old value, new value, user ID, date/time
R-115MandatorySystem AuditAutomatic audit trail logging and generate report for all queries and reports run - query/report name or SQL code, date/time, user
R-116MandatoryTrainingIDMS shall have capability to integrate with the SSI computer-based training system to provision applicant records, training required based on the badge types and privileges requested, retrieve results (pass / fail) and record expiration dates.
R-117MandatoryTrainingThe IDMS shall have the capability to restrict certain training courses. (e.g. Movement Area training is dependent on completing non-movement training.) and automatically assign renewal trainings as required by SMF.
R-118MandatoryViolationsAllow an unlimited number of violation types to be added.
R-119MandatoryViolationsRecord and track airport policy infractions in each identity profile (e.g. safety and security violations).
R-120MandatoryViolationsAllow SMF to determine if a badge should be suspended when a violation occurs, the IDMS should not automatically deactivate the badge.
R-121MandatoryViolationsTrack fulfillment of any necessary corrective actions (e.g. fines, suspension, training).
R-122MandatoryViolationsProvide ability to search existing or historical records (entered and migrated in IDMS) of infractions by multiple fields such as name, company, badge number, or violation type.
R-123MandatoryViolationsSend violation notices out via email automatically to the Authorized Signatory.

Dylan sheet

Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC)
FC-001ApplicationProvide capability for the applicant to electronically submit information related to Disqualifying crimes badge holder responsibilities, other airport specific legal language currently available in the badge application.
Process
FC-002ApplicationThe applicant portal shall be mobile friendly such that the web portal aligns to various mobile screen sizes without limiting functionality.
Process
FC-003ApplicationThe IDMS shall have capability for a website link or APP where the applicant can enter name, DOB, SSN and I9 document, with image upload capability for identity verification.
Process
FC-004ApplicationThe IDMS shall have the capability to list all complete applications submitted by the AS. If the applicant portion of the application is not complete the badge application cannot be processed by the badging office.
Process
FC-005ApplicationThe IDMS shall have capability to clearly identify the type to application such as new badge application, renewal badge application, badge change (for adding or removing privilege - escort, driving privilege), replacement badge application (name change or lost, stolen or mutilated).
Process
FC-006ApplicationThe IDMS shall allow the Trusted Agent to review and modify as necessary all the information submitted by the AS and the applicant. The Trusted agent can Accept or Reject or Cancel the badge application review step. IDMS shall send notification to AS if application is rejected or accepted.
Process
FC-007ApplicationOnce the applications are rejected, they will no longer appear in the application list for processing.
Process
FC-008ApplicationThe IDMS shall alert the Trusted agent if the new badge applicant already exists and allow the Trusted Agent to review the duplicate record and merge or process individually.
Process
FC-009AuditAudit should allow selection of records for Audit based on company, specific individuals, and badge type.
FC-010Authorized SignatoryThe IDMS shall always check and enforce the AS to maintain an active badge, valid security checks, valid AS trainings, in order to keep the AS active and maintain access to the AS portal.
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC)
FC-011Authorized SignatoryIDMS must assign each Authorized Signer a unique user account and password upon completion of the approval process and required training. This user account will be used for submission of employee badge applications and all other business activities performed using the web interface.
FC-012Authorized SignatoryIDMS shall provide and describe mechanisms to incorporate multi-factor authentication for the Authorizing Signatory Portal. The IDMS shall have the capability to implement OTP / authentication codes via text or email.
FC-013Authorized SignatoryThe IDMS shall provide capability for the AS to perform at a minimum via the AS web portal, the following functions: enroll new applicants, authorize renewal of badges, submit badge replacement applications for lost, stolen, mutilated, name changes or privilege modification changes, respond to audits, upload supporting documentation for I-9, CBP forms, driving permits, key request form, and other documentation as necessary for the airport operations.
FC-014Authorized SignatoryThe IDMS shall have capability to capture all the STA required fields during the badge application process.
FC-015Authorized SignatoryProvide the ability to send via email to a new badge applicant (mandatory field for all applicants), an expiring link to enter applicant regulatory information and acknowledgements application information and attest to a disqualifying felony statement.
FC-016Authorized SignatoryThe IDMS shall allow the badge application entered by the AS to be saved prior to submission. The application will be saved for 30 days or user defined timeframe prior to permanently deleting the application from IDMS.
FC-017Authorized SignatoryThe IDMS shall permit the Authorized Signer to select the badge type (escort or no escort), AOA privileges, access level / clearance and need for Videx key requests for a new badge application or for existing badges.
FC-018Authorized SignatoryThe IDMS shall allow AS to authorize renewal if the employee badge is due to expire within the 30 days of badge expiration.
FC-019Authorized SignatoryAt a minimum, the following should be displayed on the dashboard: The AS will see only those companies and badge holders, he / she is responsible for. The AS should see the list of applications submitted, pending, applicant acknowledgements submitted or pending, upcoming badge expirations and badge renewals, unaccounted badges.
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC)
FC-020Authorized SignatoryThe IDMS shall allow at a minimum the following badge statuses with capability for the system administrators to add / modify statuses and reason for de-activation: Active, Inactive, Suspended, Terminated, Revoked, Returned, Lost, Stolen, Damaged, The IDMS shall also provide drop down list for "Reason for De-activation"
FC-021Badge ProductionAutomatically calculate and default the maximum expiration date for each new or reissued badge based on current airport policy.
The airport’s typical badging cycle is 24 months however badge expiration dates are tied to a person’s birth month. Other factors that come into play include people with Work Authorization Documents, Visa’s, Permanent Resident Cards, and companies who are on probation due to an excessive percentage of unaccounted for badges. Those badges may be set for a 1-year period or a 6-month period.
FC-022Badge ProductionThe IDMS shall clearly indicate on the UI if the badge was returned, badge returned date, badge printed date, badge pick-up date.
FC-023Badge ProductionWhen the current date passes an assigned expiration date on a badge, automatically update the badge status to revoked with reason of expired and deactivate the badge in the DAC.
FC-024Badge ProductionAllow creation of new badges as replacements for unaccounted (e.g. lost, stolen) badges by copying previous badge details, badge expiration date and establishing a new badge number.
FC-025Badge ProductionPrint a receipt and send notification to the badge holder and / or Authorized Signatory as proof the badge was issued or surrendered.
FC-026Badge holder RecordIDMS shall permit the Badging Office staff or Trusted Agents to indicate the status of a badge as returned, badge not returned, or lost or stolen.
Management
FC-027Badge holder RecordWhen an AS or badge holder reports their badge as terminated, lost or stolen, the badge must immediately be deactivated in IDMS and the PACS.
Management
FC-028Badge holder RecordProvide ability to issue single active badges to one individual working for multiple separate companies. (Up to 3 companies on the badge)
Management
FC-029ViolationsAllow users with appropriate permissions to add new types (security and safety) of violations.
FC-030ViolationsAllow an unlimited number of violation types to be added.
FC-031ViolationsManage a central record of employee’s violations at the Airport.
FC-032ViolationsRecord and track airport policy infractions in each identity profile (e.g. safety and security violations, no insurance).
FC-033ViolationsRecord and track repeated infractions, which may warrant re-training of the employee.
FC-034ViolationsTrack the number of violations in each identity profile.
FC-035ViolationsTrack penalties relating to a suspension.
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC))
FC-036ViolationsTrack fulfillment of any necessary corrective actions (e.g. penalties, suspension, training).
FC-037ViolationsSend violation notices out via email automatically to the Authorized Signatory.
FC-038CompanyIDMS shall provide capability for the Badging Office staff to enroll a new company and provide at a minimum the following information including but not limited to company name, company start and end dates, company type (For Example: Airline, Local or Federal Government, Contract, Tenants, Vendors, Concessionaires, others) company status, clearance codes/access level assignment configurations, contract information, contract start and end dates, sponsor contractor information.
FC-039CompanyIDMS shall provide ability to capture company names as - Business Legal name, doing business as, abbreviated name to be printed on the badge.
FC-040CompanyIDMS shall provide the ability to store multiple company addresses, phone numbers and multiple company contacts information including name, email, job title.
FC-041CompanyIDMS shall provide capability to configure at company and division level the ID requirements (certain government employees can provide one I9 document), access levels/clearance codes, financials (monthly billing, fee waived), payments (badge fees, other fees), security check exemptions (CHRC, STA, others).
FC-042CompanyIDMS shall provide capability for the Badging Office to scan and / or upload documents related to company enrollment. For example, company authorization letter, contract documents, insurance certificate, nominate first Authorized Signatory for the company, and others as required by the Airport. The documents will be saved in the IDMS and be available and the archived/ deleted as per the airport data retention policy.
FC-043CompanyThe IDMS shall allow tracking of the Company statuses. At a minimum the following should be available Active, Inactive, Suspended, Terminated, and others as per the Airport business requirements.
FC-044CompanyThe IDMS shall have capability to add Reason for de-activation or add notes to company profile when the company status has changed from active to another status.
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC)
FC-045CompanyThe IDMS shall allow suspension of a company such that existing active badges will not be automatically de-activated when the status has changed, however will enforce any future processing of the company employees for badge printing or badge renewals. (Example case: company has financial payments due/ defaulted)
FC-046CompanyThe IDMS shall enforce that a Company in Active status should have at least one (1) active Authorized Signatory. There is no limit on the number of Authorized signatories that a company can designate. Use of global AS or badging office manager for 1st AS enrollment is acceptable. A notification within the IDMS needs to be made to the Badging Office staff.
FC-047CompanyThe IDMS shall have capability to allow the badging office to set an authorized signatory as Active or Inactive.
FC-048CompanyProvide capability for Badging Office to configure default access levels / clearance codes for an approved company. The default access levels / clearance codes will be visible in the company profile.
FC-049CompanyProvide capability for the Badging Office or system administrator to modify the default access levels / clearance codes per company business requirements.
FC-050CompanyThe IDMS should provide capability for badging office manager to perform bulk / volume tasks such as de-activation of badges, badge printing, change access levels/clearance codes by badge type or company or divisions.
FC-051CompanyThe IDMS shall provide functionality to change company names (e.g. legal name changes and badge printed names) including providing report of all badge holders impacted. Allow corporate name changes while retaining relation to the former corporate name.
FC-052CompanyThe IDMS shall provide functionality to allow merger of companies (e.g. legal name changes and badge printed names) including providing report of all badge holders impacted.
FC-053DashboardThe IDMS shall provide immediate notification on dashboard and email notification to the system administrators, badging office and ASC if the connection to any DACS is lost.
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC)
FC-054DashboardThe IDMS can provide a dashboard for Badging Office staff and the AS. The dashboard should be configurable for each user group and user.
FC-055DashboardProvide on dashboard those STA and CHRC results that have not been returned in 10 business days.
FC-056DocumentIDMS will enable association of scanned documents with badge applications. IDMS must accommodate for all identification types shown on the Acceptable Documents List (List A, B & C).
Management
FC-057DocumentProvide ability to restrict viewing of scan and stored documents (e.g. Rap sheets) and mark private based on user roles by permission levels.
Management
FC-058DocumentProvide Badging Office staff an input form for capturing identification document data with appropriate fields displayed based on the type of identification provided.
Management
FC-059DocumentBe able to rotate and zoom in to review scanned documents. The upload document formats will be pdf or image files. Use of Adobe acrobat to rotate or zoom is acceptable for pdf files
Management
FC-060DocumentProvide ability to compare the data retrieved from the documents against the data entered by the AS or Applicant including ability to select data fields to merge or ignore.
Management
FC-061DocumentProvide the ability to archive electronic documents and badge records automatically on preset schedule following airport data retention policies.
Management
FC-062Email NotificationsIDMS shall support the use of templates for emails to the Security Badging Office staff, companies, and Authorized Signers.
FC-063Email NotificationsProvide notification to the Authorized Signatory when a badge status changes within the Authorized Signatory’s company.
FC-064Email NotificationsIDMS shall allow system administrators to add / modify wording within and database references for field values in the email templates.
FC-065Email NotificationsProvide ability to notify Badging Office, AS, and applicant when a specified document in a record expires (e.g. driver’s license, passport, authorization to work).
FC-066Email NotificationsProvide capability to send various notifications with reminders and escalations to the Authorized Signatory, Airport Badging, ASC.
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC)
FC-067Email NotificationsNotifications to AS, applicant and Badging Office for various statuses during badge application process (e.g. pre-enrollment, fingerprinting, security checks complete, training complete (pass/fail), badge issued, violations issued); scheduling appointments (e.g. fingerprinting, document submissions, badge pickup, renewals, key and training, badge applicant -No show to appointments, applicant failed to pick up badge within 30 days from the security checks completed).
FC-068Email NotificationsNotifications to AS, Applicant and Badging Office - Expirations: badge, training, documents, and audit responses.
FC-069Email NotificationsProvide notification if the connection to PACS is lost.
FC-070FinancialAllow payment methods to be defined at individual company levels. (e.g. while one company might be authorized to receive a single invoice at the end of the month for all services rendered by the Security Badging Office, another company may be required to pay for each badge or credential or service with a check or credit card at the time the service is rendered or at the time the appointment is booked.)
FC-071FinancialProvide the capability to manage and track the fees / charges associated with badges, background investigations, and other items issued in the Security Badging Office (e.g. keys, permits, card holders).
FC-072FinancialIDMS shall be capable to generate and export reports that show (itemized or grouped) all the financial transactions by badge holder (name, badge #, date, amount, payment method, payment type, etc.) grouped by company over any period of time (a day, a week, a month, year-to-date, or since system inception).
FC-073FinancialSupport user-defined badge billing rate classes by company and badge type, considering CHRC exemptions, external adjudication, and federal employee allowances.
FC-074GeneralThe IDMS shall follow the badging procedures and regulatory requirements as outlined in the Code of Federal Regulations (CFR) Title 49 Chapter XII Part 1542, active aviation security policy enforcement, ASP amendments, National amendments issued and Security Directives (SD) 1542-04-08 or subsequent updates.
FC-075GeneralIDMS shall assign a Unique ID number for each person employed at the airport regardless of the number of companies they work for and cannot be related to the person's name, SSN, or any other PII data. This ID will be used across all systems and will remain constant for that person.
FC-076GeneralAllow capability to search the database using multiple fields and combinations of those fields as search criteria.
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC)
FC-077GeneralIDMS shall be intuitive and easy to follow requiring minimum training. The UI shall drive the user to completing relevant tasks and clearly display next step and missing mandatory information.
FC-078GeneralThe IDMS shall clearly display on the badge holder record the stage / status the person is in at any given time. E.g. Pending security checks, incomplete training, etc.
FC-079GeneralEnsure standard drop-down lists/master data values are sorted alphabetically (e.g. US states, Country names, Ethnicity,). Ensure commonly used drop down/ master data values are on the top (e.g. United states country when entering Passport or DL)
FC-080GeneralThe IDMS shall have field formatting and validations. For example: age minimum limit configurable, height cannot be in inches only and cannot be 10' or cannot accept alpha characters for age, height, weight. Ensure the UI enforces data type, field length, and formatting limitations as per all the dependent subsystems (i.e. PACS, fingerprinting etc.).
FC-081GeneralProvide the capability to mask all or specific Personal Identifiable Information (PII) (e.g. SSN) and non-PII (e.g. PIN) data fields for display after initial input. The masking will be based on business rules and allow the airport to modify PII fields. The UI will clearly indicate if the data is entered or not entered or missing.
FC-082GeneralProvide the capability that the masked data fields are viewable to certain user groups like Airport Security Manager, ASC or designees as determined by the Airport.
FC-083GeneralProvide ability in the UI to override business rules (supervisor override) on a case-by- case basis to certain user groups (ASC, Security Manager). E.g.: applicant from Law enforcement agencies may not be always exempt from CHRC and STA, allows ASC or designee to override the global rule form the UI for the applicant)
FC-084GeneralAllow field validations for name fields, date fields, zip codes, phone #s, SSN, DL#, Passports and ARN# etc. Allow selection of country, state where applicable.
FC-085GeneralProvide invalid or non-conforming entries (E.g. red color) on the screen and prevent invalid or incomplete submissions.
FC-086GeneralSupport entering unlimited notes / comments associated with persons, company, security checks, training, badges, access levels, keys, each of which is automatically user/date/time stamped.
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC)
FC-087GeneralRestrict Trusted Agent ability to change/delete comments they entered. Allow Security Manager or ASC or other designated Trusted agents to make modification to the comments entered by the Trusted agents.
FC-088GeneralProvide ability to make comments private/ secured based on user roles
FC-089GeneralAllow operators to flag a note/comment so that the note/comment will be immediately displayed when any user subsequently accesses the record until the user that made the comment, or a supervisor change or deletes the note/comment. For example: SOC users, LEO or CBP marks a record for suspension or revocation the Trusted Agent should get notification immediately.
FC-090Integration DACSThe IDMS shall have capability to provide automated method to enroll badge holder in Rap back program upon submission of fingerprint to DACS and not wait for badge issuance. Standard Rap Back subscription, cancel and uncanceled rules applicable.
FC-091Integration DACSThe IDMS shall have capability to integrate with DAC and submit the data for STA, CHRC and Rap-back.
FC-092Integration DACSThe IDMS shall have the capability to send notifications to the AS (via email to the AS) if the applicant has failed one or both (STA and CHRC) security checks. The IDMS shall track date when the security checks status was changed. The IDMS shall allow the Badging Office to set the background checks status to Appeals if the Applicant has appealed the CHRC results within 30 days. The IDMS shall limit further processing of training, or badge issuance for the applicant if the background check is in appeals process.
FC-093Integration DACSThe IDMS shall obtain change in status information from the DAC for CHRC and notify the Badging Office when the results are available on the FBI FPRD.
FC-094Integration DACSAutomatically retrieve results from the DAC and update / populate matched STA results to the existing badge holder database.
FC-095Integration DACSThe IDMS shall send notifications to AS and Applicant when security checks are complete, with instructions for next steps.
FC-096Integration DACSThe IDMS shall provide capability to electronically submit the supporting documents to the DAC.
FC-097Integration DACSProvide the functionality to limit the review of background check results to authorized personnel.
FC-098Integration FingerprintLivescan Fingerprint system (existing system – Fulcrum Biometrics software, Green-bit Scanner, or compatible vendor software.)
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC)
FC-099Integration PACSUpdate PACS with badge holder, badge, and clearance codes data immediately (within operational acceptable timeframe). Update requests shall be queued for processing without delay.
FC-100Integration PACSWhen an employee reports their badge as lost or stolen, the badge must immediately be deactivated in IDMS and the PACS.
FC-101Integration PACSProvide ability to manage higher level of grouping / mapping of clearance codes based on job titles, privileges (e.g. movement area driving would allow assignment of vehicle gate clearance and emergency privilege mapping to all access).
FC-102Integration PACSIDMS will provide a means to define and create templates or other methods of setting default clearance code / groups for employees of a company based on variables such as company name, company type, badge type, privileges, job title, department/division.
FC-103Integration PACSProvide capability to auto assign clearance codes at a minimum based on job title, company name, company type, badge type. Allow manual override of the clearance codes (adding or deleting) by the Trusted Agent.
FC-104Integration PACSSupport an unlimited number of access levels per badge or credential type.
FC-105Integration PACSBulk access levels assignments and removals from badge holders
FC-106ReportsAll reports be capable of being exported into multiple formats (at a minimum .csv, .pdf and .xlsx formats).
FC-107ReportsThe IDMS can provide reports for reconciling badge holder records between DAC and IDMS.
FC-108ReportsThe IDMS can provide reports for financial reconciliation of fingerprinting, STA, CHRC and Rap-back fees against the DAC financial reports.
FC-109ReportsProvide ability to list all open, closed, pending violations.
FC-110ReportsGenerate reports based on the status of matches (e.g. cleared, under investigation, actual match).

ID#AAABOGwVy1I Jamie Hansen (2024-06-07 23:07:37) @dylan@airbadge.us @nathan@airbadge.us have compared this against the PDF copy submitted and there was a line deleted from the Excel file they gave us. I added the line from the PDF to this file - I'm assuming they still want us to respond to it.

_Assigned to dylan@airbadge.us_FC-111ReportsProvide pre-defined reports, in a variety of formats that allow the user to select or specify the grouping and / or sorting criteria.
FC-112ReportsEasily generate ad-hoc reports or queries without specialized skills (most easily via filtering, sorting, grouping).
Functional CapabilitiesContractor Response
IDFunctional AreaCapabilities DescriptionMeetsComments
Capabilities (C)
Doesn't Meet
Capabilities (NC))
FC-113ReportsProvide ability for a system user to create new reports as well as modify existing reports.
FC-114ReportsDaily and monthly reports will be created, stored, and managed within IDMS. Standard reporting tools, such as SQL Server Reporting Services or Crystal Reports must be supported.

This is the start of the file's text. The full file is on GovTribe.

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