Section J_ATTACHMENT D2_GSS Notional Data Definition for Management Information.xlsx
XLSX spreadsheet 17 KB Posted
- Solicitation number
- SAQMMA09R0277
About this file
Section J Attachment D2 GSS Notional Data Definition for Management Information
View the file
Other files
Show all 30
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
Sheet1
| ATTACHMENT D2 - GSS Notional Data Definition for Management Information |
| (does not include data elements specific to performance metrics) |
| FIELD | DATA TYPE | SPECIAL FORMAT | PUNCTUATION PERMITTED | COMMENT |
| Surname | Varchar2 (33) | Y | ||
| Given Name | Varchar2 (33) | Y | ||
| Nationality | Varchar2 (50) | Y | To be validated against USG codes | |
| Date of birth | Date | |||
| Place of birth | Varchar2 (50) | Y | To be validated against USG codes | |
| Gender | Varchar2 (1) | M/F | ||
| Passport Number | Varchar2 (30) | May have leading zero | ||
| Place of Issuance | Varchar2 (50) | Y | To be validated against USG codes | |
| Date of Issuance | Date | Minimum 1/1/1900; maximum SYSDATE | ||
| Date of Expiration | Date | Greater than SYSDATE | ||
| Address Line1 | Varchar2 (50) | Y | ||
| Address Line2 | Varchar2 (50) | Y | ||
| City | Varchar2 (30) | Y | ||
| State | Varchar2 (20) | Y | ||
| Postal Code | Varchar2 (10) | |||
| Email address | Varchar2 (50) | Y | ||
| Home Phone | Varchar2 (20) | Y | ||
| Work Phone | Varchar2 (20) | Y | ||
| Other Phone | Varchar2 (20) | Y | ||
| NIV Visa Class Code | Varchar2 (7) | Y | To be validated against USG codes | |
| IV Case ID | Varchar2 (25) | N | ||
| IV Petitioner Name | Varchar2 (75) | Y | May contain special characters | |
| NIV Case ID | Varchar2 (17) | N | ||
| Date Previous NIV Visa Expired | Date | |||
| Barcode Number | Varchar2 (10) | May have leading zero | ||
| Embassy/Consulate where applicant will apply | Varchar2 (3) | To be validated against USG codes | ||
| Contractor Location | Varchar2(50) | |||
| In instances where information services are provided, records should include the following elements: | ||||
| User ID | Varchar2 (30) | |||
| Case Created Date & Time | Date | |||
| Embassy/Consulate where applicant will apply | Varchar2 (3) | To be validated against USG codes | ||
| Contractor Location | Varchar2(50) | |||
| Length of service transaction | TBD | |||
| Comment | Varchar2(250) | Free form text | ||
| In instances where appointment services are provided, records should be created any time an appointment is scheduled (whether first appointment or rescheduled appointment) and should include the following elements: | ||||
| User ID | Varchar2 (30) | |||
| Case Created Date & Time | Date | |||
| Embassy/Consulate where applicant will apply | Varchar2 (3) | To be validated against USG codes | ||
| Contractor Location | Varchar2(50) | |||
| Length of service transaction | TBD | |||
| Comment | Varchar2(250) | Free form text | ||
| Appointment Date | Date | DD-MON-YYYY | ||
| Appointment Time | Date | HH24:MI | ||
| Appointment Site | Varchar2 (3) | To be validated against USG codes | ||
| Appointment Office Name | Varchar2 (50) | |||
| Appointment Type | Varchar2 (20) | |||
| Comment | Varchar2(250) | Free form text | ||
| In instances where fee collection services are provided, records should include the following elements: | ||||
| Collection User ID | Varchar2 (30) | |||
| Collection Date & Time | Date | |||
| Deposit User ID | Varchar2 (30) | |||
| Deposit Date & Time | Date | |||
| Amount | Number(14, 2) | U.S. dollar | ||
| Contractor Location | Varchar2(50) | |||
| Comment | Varchar2(250) | Free form text | ||
| In instances where document delivery services are provided, records should include the following elements: | ||||
| User ID | Varchar2 (30) | |||
| Pickup Date & Time | Date | |||
| Embassy/Consulate where applicant will apply | Varchar2 (3) | To be validated against USG codes | ||
| Contractor Location | Varchar2(50) | |||
| Courier Company Name | Varchar2 (50) | |||
| Courier Tracking Number | Varchar2 (20) | |||
| Document Departure Site Code | Varchar2 (3) | |||
| Document Departure Date & Time | Date | |||
| Document Arrival Location | Varchar2 (50) | |||
| Document Arrival Date & Time | Date | |||
| Comment | Varchar2(250) | Free form text | ||
| In instances where offsite data collection services are provided, records should include the following elements: | ||||
| User ID | Varchar2 (30) | |||
| Date & Time | Date | |||
| Embassy/Consulate where applicant will apply | Varchar2 (3) | To be validated against USG codes | ||
| Contractor Location | Varchar2(50) | |||
| Location of Activity | Varchar2 (50) | |||
| Length of service transaction | TBD | |||
| Comment | Varchar2(250) | Free form text |
File details come from the government source that posted it. Updated .