Definition of table user-access
User access restrictions file. If there is no restriction record for an employee, then they have full access. Otherwise, we limit it to the given catagories. , Table Dump Name user-acc

Alphabetical Field Summary

  • allow-company: (CHAR) List of companies to allow access to
  • allow-department: (CHAR) List of departments to allow access to
  • allow-division: (CHAR) List of divisions to allow access to
  • allow-group: (CHAR) List of employee groups to allow access to
  • allow-job: (CHAR) List of job codes to allow access to
  • allow-location: (CHAR) List of locations to allow access to
  • cre-date: (DATE) Date this record was created
  • cre-user-name: (CHAR) Name of user who created this record
  • extern-guid: (CHAR) External Global Unique ID for this record
  • override-ssn: (CHAR) List of override SSN's that are always allowed
  • primary-key: (INTG) Unique, Primary key for record
  • upd-date: (DATE) Date this record was last updated
  • upd-user-name: (CHAR) Name of user who last updated this record
  • user-name: (CHAR) Login name of user to place restrictions on
  • view-unlisted: (LOGC) Yes to allow viewing unlisted employees, No otherwise.

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • user-name: (UNIQUE, PRIMARY) user-name

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-uac.p
  • DELETE: Overridable, Procedure is tr-d-uac.p
  • REPLICATION-CREATE: Procedure is rp-c-uac.p
  • REPLICATION-DELETE: Procedure is rp-d-uac.p
  • REPLICATION-WRITE: Procedure is rp-u-uac.p
  • WRITE: Overridable, Procedure is tr-u-uac.p

    Other tables who reference user-access

  • aca-benefit-plan - ACA Benefit Plan codes
  • aca-category-code - (no description available)
  • aca-coverage-code - ACA Coverage Codes
  • aca-safe-harbor-code - (no description available)
  • accr-code - Accrual Block Code Definitions
  • accr-group - Accrual Group Code
  • atnd-accr - Attendance code -> Accrual Code assignments
  • atnd-code - Attendance Code Definitions
  • atnd-group - Attendance Code Ground definitions
  • atnd-unit - Attendance Unit Code Definitions
  • benefit-class - Benefits Class definitions
  • benefit-code - Benefit Code Descriptions
  • cert-code - Certification Area codes
  • cert-type - Certification Type codes
  • comp-code - Company Code definitions
  • contact-code - Contact Code definitions
  • dc-record-type - (no description available)
  • dc-status-reason - (no description available)
  • degree-study - Areas of study for the degree
  • degree-type - Degree Type Definitions
  • dept-code - Department Code Definitions
  • district-1094c - (no description available)
  • div-code - Division Code Definitions
  • emp-aca - (no description available)
  • emp-accr - Employee Accrual Blocks
  • emp-atnd - Employee Attendance Entries
  • emp-benefit - Employee Benefits
  • emp-contact - Employee Contacts
  • emp-dc - (no description available)
  • emp-degree - Employee Degrees
  • emp-demo - Employee Demographic Entry
  • emp-dependent - Employee Dependent Definition file
  • emp-event - (no description available)
  • emp-fringe - (no description available)
  • emp-group - Employee Groupings File
  • emp-history - Employee Demographic Entry
  • emp-mpsers - (no description available)
  • emp-note - Employee Notes file
  • emp-prof - Employee Professional Catagories
  • emp-site - Site Specific Employee data file
  • emp-state-item - Describes an employee state record entry
  • emp-tdp - Employee DTL3 record
  • ethnic-code - Ethnic Code definitions
  • event-code - (no description available)
  • event-group - (no description available)
  • fringe-class - Fringe benefit classes
  • fringe-code - (no description available)
  • fringe-period - Fringe Benefit Period
  • grant-fund - (no description available)
  • history-code - Employee History Activity Codes
  • hrs-prof - HRS System wide profile
  • job-code - Definition of district job codes
  • loc-code - Location Codes
  • marital-code - Marital Status Codes
  • mpsers-period - (no description available)
  • mu-stat - Mass Update Status flags file
  • note-code - Definition of each of the possible note codes
  • pay-activity - Activity associated with Salary paid
  • pay-assign - Payroll Assignments
  • pay-assign-role - Role & Service of Pay Assignment
  • permit-grade - Permit/Certification Grade Levels
  • permit-pop - Population Served with Permit/Certification
  • permit-status - Permit/Certification Status
  • permit-subject - Permit/Certification Subject Areas
  • permit-type - Permit Issuance/Renewal Types
  • prof-cert - Profession Catagory Certifications
  • prof-code - Profession Catagory Codes
  • relate-code - Describes relationships between other persons and the employ
  • role-code - Role within position for which salary is paid
  • service-code - Service Codes for salary paid
  • site-fld-define - Site Field definitions
  • site-fld-group - Site field to user group mapping file. This is the interface
  • site-frame - Site Defined frame definitions
  • site-table-code - Site Table Codes
  • site-table-name - Site Table Names
  • status-code - Employee Status Codes
  • study-type - Code describing type of study
  • tdp-adjustment-type - TDP Adjustment type codes for MPSERS
  • tdp-deduct-reason - (no description available)
  • tran-code - Real World Translation Definitions
  • univ-code - University Codes
  • wage-code - (no description available)
  • _User - (no description available)


    Detailed Alphabetical Field Listing
    allow-company Data type: CHARACTER
    Format: x(60) (Initial Value: *)
    Description: List of companies to allow access to
    Help: List of companies allowed, '*' for all, '!company' to omit o

    allow-department Data type: CHARACTER
    Format: x(60) (Initial Value: *)
    Description: List of departments to allow access to
    Help: List of department allowed, '*' for all, '!dept' to omit one

    allow-division Data type: CHARACTER
    Format: x(60) (Initial Value: *)
    Description: List of divisions to allow access to
    Help: List of divisions allowed, '*' for all, '!division' to omit

    allow-group Data type: CHARACTER
    Format: x(60) (Initial Value: *)
    Description: List of employee groups to allow access to
    Help: List of groups allowed, '*' for all, '!group' to omit one

    allow-job Data type: CHARACTER
    Format: x(60) (Initial Value: *)
    Description: List of job codes to allow access to
    Help: List of job codes allowed, '*' for all, '!job' to omit one

    allow-location Data type: CHARACTER
    Format: x(60) (Initial Value: *)
    Description: List of locations to allow access to
    Help: List of locations allowed, '*' for all, '!location' to omit

    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was created

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: Name of user who created this record
    Attributes: Mandatory

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    override-ssn Data type: CHARACTER
    Format: x(70)
    Description: List of override SSN's that are always allowed
    Help: Employee SSN that are allowed regardless of other criteria

    primary-key Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Unique, Primary key for record

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was last updated

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user who last updated this record

    user-name Data type: CHARACTER
    Format: x(16)
    Help: Login name of user to place restrictions on
    Attributes: Index Component, Mandatory

    view-unlisted Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to allow viewing unlisted employees, No otherwise.

    Created on 12/28/2020 by DBHTML V1.2