This table contains location sites used in the Career Tech module.
|CareerTechLocalityID||19.11.0||Number(10,0)||Internal number for the associated CareerTechLocality record. Indexed individually and with YearID and SiteName. Required.|
Unique sequential number generated by the application. Indexed. Required.
The city element of the address. Optional.
|CountryCodeSetID||19.11.0||Number(16,0)||Internal number for the associated CodeSet Country record. Indexed. Optional.|
The latitude coordinates for the site's address. Optional.
|GeoCodeLongitude||19.11.0||Number(16,10)||The longitude coordinates for the site's address. Optional.|
|IsActive||19.11.0||Number(1,0)||Indicates whether this site is visible to users as a selection option. Valid values: 1=True, 0=False. Default 1. Required.|
|LineTwo||19.11.0||Varchar2(100)||The second line of the address. Optional.|
|PostalCode||19.11.0||Varchar2(10)||The zip code element of the address. Optional.|
|SchoolDCID||19.11.0||Number(10,0)||Internal number for the associated School record. Optional. Indexed with YearID when populated.|
|SiteName||19.11.0||Varchar2(100)||The name of the site. Indexed with YearID and CareerTechLocalityID. Required.|
|StatesCodesetID||19.11.0||Number(16,0)||Internal number for the associated CodeSet State record. Indexed. Optional.|
|Street||19.11.0||Varchar2(100)||The street name and number element of the address. Usually line one of the address. Optional.|
|Unit||19.11.0||Varchar2(30)||The suite or apartment number element of the address. Optional.|
|WhenCreated||19.11.0||Timestamp(6)||The date and time the record was created. Defaults to system date. Required.|
The date and time the record was modified. Defaults to system date. Required.
The name of the person who created the record. Defaults to user. Required.
The name of person who modified the record. Defaults to user. Required.
A number representing which year the term belongs to, such as 19 for 2019-2020.
The number is equal to the ID of the year term divided by 100. Required.
Indexed with SchoolDCID if SchoolDCID is populated and with SiteName and CareerTechLocalityID.