Enable record-level security for a system table and field

Enable record-level security for a Data Dictionary system table, then for the data field associated with that table.

The following data fields and their associated Data Dictionary system tables are set up for record-level security by default:

Name	JavaName	Name	Reference Table > Name
CJO_FEE_TYPE	feeType	Fee type	Fees and Fines
CND_INCIDENT_CODE	incidentCode	Primary code	Conduct Incident
PGM_PROGRAM_CODE	programCode	Program code	Student Programs
DOC_TYPE_CODE	typeCode	Type	Document Type Codes
JNL_TYPE	type	Type	Student journal type

To enable a Data Dictionary system table and data field for record-level security:

1. Log on to the District view.
2. Click the Admin tab, Data Dictionary side-tab.
3. Click the Tables side-tab.
4. Select the system table that appeared in the DataTable > DBName column on the reference table fields page.
5. Click Details.
6. From the Default Template drop-down, select Default Fields.
7. Select the Enable record level security checkbox, and click Save:

8. 

8. On the Table side-tab, click Fields. The fields associated with this Data Dictionary system table appear.
9. Select and open the field that you want to enable for record-level security.
10. From the Default Template drop-down, select Default Fields.
11. Select the Enable record level security checkbox, and click Save:
12. 

12. From the Default Template drop-down, select Default Template.
13. Look at the Reference Table > User name field. Note the name of the reference table that appears. If the field is blank, enter a reference table to associate with this system table field.

Note: A reference code must be associated with this reference table to enable record-level security.

14. Click Save.
15. Reload the Data Dictionary.

Then you can set up record-level security for the reference table associated with the field.