Federal fields are modeled as UDA in procurement documents that can be used in Contract Expert. Predefined contract variables corresponding to federal fields are available. You can create rules using these variables, as you would for any other variables. At runtime, Procurement Contracts calls the UDA APIs to fetch the value corresponding to the federal fields for that document. The list of predefined variables is as follows:
Contract Variable Name | Attribute Group Name | Attribute Name |
---|---|---|
Set Aside Type | Competitive Information | Set Aside Type |
Set Aside Status | Competitive Information | Set Aside Status |
Set Aside Percentage | Competitive Information | Set Aside Percent |
Size Standard | Competitive Information | Size Standard |
SAM Exception Reason | Supplier Details | SAM Exception Reason |
EFT Exclusion Reason | Supplier Details | EFT Exclusion Reason |
Vendor Size | Supplier Details | Supplier Size |
Authority for Other than Full and Open Competition | Award Categorization | No Competition Reason |
Administration Office Location Name | Addresses | Location |
Administration Office Location Code | Addresses | Address Code |
Administration Office Address Line1 | Addresses | Address Details XML |
Administration Office Address Line2 | Addresses | Address Details XML |
Administration Office City | Addresses | Address Details XML |
Administration Office Country | Addresses | Address Details XML |
Administration Office Postal Code | Addresses | Address Details XML |
Administration Office State | Addresses | Address Details XML |
Administration Office Contact Name | Addresses | Contact |
Administration Office Contact Email | Addresses | Contact Details XML |
Administration Office Contact Telephone Number | Addresses | Contact Details XML |
Administration Office Contact Title | Addresses | Contact Details XML |
COR Office Location Name | Addresses | Location |
COR Office Location Code | Addresses | Address Code |
COR Office Address Line1 | Addresses | Address Details XML |
COR Office Address Line2 | Addresses | Address Details XML |
COR Office City | Addresses | Address Details XML |
COR Office Country | Addresses | Address Details XML |
COR Office Postal Code | Addresses | Address Details XML |
COR Office State | Addresses | Address Details XML |
COR Office Contact Name | Addresses | Contact |
COR Office Contact Email | Addresses | Contact Details XML |
COR Office Contact Telephone Number | Addresses | Contact Details XML |
COR Office Contact Title | Addresses | Contact Details XML |
Invoice Office Location Name | Addresses | Location |
Invoice Office Location Code | Addresses | Address Code |
Invoice Office Address Line1 | Addresses | Address Details XML |
Invoice Office Address Line2 | Addresses | Address Details XML |
Invoice Office City | Addresses | Address Details XML |
Invoice Office Country | Addresses | Address Details XML |
Invoice Office Postal Code | Addresses | Address Details XML |
Invoice Office State | Addresses | Address Details XML |
Invoice Office Contact Name | Addresses | Contact |
Invoice Office Contact Email | Addresses | Contact Details XML |
Invoice Office Contact Telephone Number | Addresses | Contact Details XML |
Invoice Office Contact Title | Addresses | Contact Details XML |
Issuing Office Location Name | Addresses | Location |
Issuing Office Location Code | Addresses | Address Code |
Issuing Office Address Line1 | Addresses | Address Details XML |
Issuing Office Address Line2 | Addresses | Address Details XML |
Issuing Office City | Addresses | Address Details XML |
Issuing Office Country | Addresses | Address Details XML |
Issuing Office Postal Code | Addresses | Address Details XML |
Issuing Office State | Addresses | Address Details XML |
Issuing Office Contact Name | Addresses | Contact |
Issuing Office Contact Email | Addresses | Contact Details XML |
Issuing Office Contact Telephone Number | Addresses | Contact Details XML |
Issuing Office Contact Title | Addresses | Contact Details XML |
Payment Office Location Name | Addresses | Location |
Payment Office Location Code | Addresses | Address Code |
Payment Office Address Line1 | Addresses | Address Details XML |
Payment Office Address Line2 | Addresses | Address Details XML |
Payment Office City | Addresses | Address Details XML |
Payment Office Country | Addresses | Address Details XML |
Payment Office Postal Code | Addresses | Address Details XML |
Payment Office State | Addresses | Address Details XML |
Payment Office Contact Name | Addresses | Contact |
Payment Office Contact Email | Addresses | Contact Details XML |
Payment Office Contact Telephone Number | Addresses | Contact Details XML |
Payment Office Contact Title | Addresses | Contact Details XML |
Property Administration Office Location Name | Addresses | Location |
Property Administration Office Location Code | Addresses | Address Code |
Property Administration Office Address Line1 | Addresses | Address Details XML |
Property Administration Office Address Line2 | Addresses | Address Details XML |
Property Administration Office City | Addresses | Address Details XML |
Property Administration Office Country | Addresses | Address Details XML |
Property Administration Office Postal Code | Addresses | Address Details XML |
Property Administration Office State | Addresses | Address Details XML |
Property Administration Office Contact Name | Addresses | Contact |
Property Administration Office Contact Email | Addresses | Contact Details XML |
Property Administration Office Contact Telephone Number | Addresses | Contact Details XML |
Property Administration Office Contact Title | Addresses | Contact Details XML |
Requesting Office Location Name | Addresses | Location |
Requesting Office Location Code | Addresses | Address Code |
Requesting Office Address Line1 | Addresses | Address Details XML |
Requesting Office Address Line2 | Addresses | Address Details XML |
Requesting Office City | Addresses | Address Details XML |
Requesting Office Country | Addresses | Address Details XML |
Requesting Office Postal Code | Addresses | Address Details XML |
Requesting Office State | Addresses | Address Details XML |
Requesting Office Contact Name | Addresses | Contact |
Requesting Office Contact Email | Addresses | Contact Details XML |
Requesting Office Contact Telephone Number | Addresses | Contact Details XML |
Requesting Office Contact Title | Addresses | Contact Details XML |
Small Business Administration Office Location Name | Addresses | Location |
Small Business Administration Office Location Code | Addresses | Address Code |
Small Business Administration Office Address Line1 | Addresses | Address Details XML |
Small Business Administration Office Address Line2 | Addresses | Address Details XML |
Small Business Administration Office City | Addreses | Address Details XML |
Small Business Administration Office Country | Addresses | Address Details XML |
Small Business Administration Office Postal Code | Addresses | Address Details XML |
Small Business Administration Office State | Addresses | Address Details XML |
Small Business Administration Office Contact Name | Addresses | Contact |
Small Business Administration Office Contact Email | Addresses | Contact Details XML |
Small Business Administration Office Contact Telephone Number | Addresses | Contact Details XML |
Small Business Administration Office Contact Title | Addresses | Contact Details XML |
Following is the list of predefined variables (non-UDA) that are used as federal attributes in Contract Expert:
Contract Variable Name | Business document Mapping Table Name | Business document Mapping Column Name (Description) |
---|---|---|
Closing Date | PO_HEADERS_ALL | CLOSED_DATE (Closed Date) |
Effective Date | PO_HEADERS_ALL | CLM_EFFECTIVE_DATE (Effective Date) |
Referenced external IDV/GSA Schedule Number | PO_HEADERS_ALL | CLM_EXTERNAL_IDV (External IDV number) |
Type | PO_HEADERS_ALL | CLM_AWARD_TYPE (Award Type) |
Vendors Offer Number | PO_HEADERS_ALL | CLM_VENDOR_OFFER_NUMBER (Supplier Offer Number) |
Format | PO_HEADERS_ALL | CLM_DOCUMENT_FORMAT (Document Format) |
The file okcclmvar.sql contains the predefined variables and is part of the CLM feature pack.