Database Administration

What would you like to do?

Public

• View a project by ID number

Staff

• Change your password

Database Administrator Only

• Assign parent units
• Reports:
  • Review new projects (0)
  • Review projects ready to be archived (47)
  • Review projects created between:
    

    MON010203040506070809101112 - DAY01020304050607080910111213141516171819202122232425262728293031 - YEAR200320042005200620072008 and MON010203040506070809101112 - DAY01020304050607080910111213141516171819202122232425262728293031 - YEAR200320042005200620072008

  • Review projects archived between:
    

    MON010203040506070809101112 - DAY01020304050607080910111213141516171819202122232425262728293031 - YEAR200320042005200620072008 and MON010203040506070809101112 - DAY01020304050607080910111213141516171819202122232425262728293031 - YEAR200320042005200620072008

  • Review ongoing projects
  • Check Site Statistics
  • List aging projects
    • List project that haven't been updated in 3 months
    • List project that haven't been updated in 6 months
    • List projects that haven't been updated in 12 months
• Add to tables:
  • Project
  • UNC Unit
  • Collaborator
  • Location
  • Contact
  • Users
• Edit tables:
  • SQL Query
  • UNC Unit
  • Collaborator
  • Location
  • Contact
  • Users