Computer Operations/sandbox

Sam:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record
name
rank
birthday
lastupdate
joindate
username
password
db restricted
active
lds101
lds201
com101
contact data change
contact data add
contact data delete
contact data show/noshow
service data change
service data add
service data delete
service data set admin flag

CD:=

O-Own Record
E-Everyones
This figures in after 'viewing record' of editing privilages in applicable areas.Let me know if more info is needed.

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record	X(Own and everyones)	X(own)	X(Own and crew)	X(Own and CO,XO's, ?Staff?)	X(Own and ?Staff?)	(X(Own and Student Courses)
name	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO)	X(O)	X(O)
rank	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)	X(O, ?staff?)	X(O)
birthday	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO)	X(O)	X(O)
lastupdate	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO)	X(O)	X(O)
joindate	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)	X(O, ?staff?)	X(O)
username	X(O+E)	X(O)	X(O)	X(O)	X(O)	X(O)
password	X(O+?E?)	X(O)	X(O)	X(O)	X(O)	X(O)
db restricted	X(O+E)
active	X(O+E)		X(O+Crew)	X(O+CO,XO?staf?)
lds101	X(O+E)	X(O-view only)	X(O+Crew-view only)	X(O+CO,XO?staf?-view only)	X(O, ?staff?-view only)	X(Own Students)
lds201	X(O+E)	X(O-view only)	X(O+Crew-view only)	X(O+CO,XO?staf?-view only)	X(O, ?staff?-view only)	X(Own Students)
com101	X(O+E)	X(O-view only)	X(O+Crew-view only)	X(O+CO,XO?staf?-view only)	X(O, ?staff?-view only)	X(Own Students)
contact data change	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)
contact data add	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)
contact data delete	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)
contact data show/noshow	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)
service data change	X(O+E)			X-Some		X(Own Students)
service data add						X(Own Students)
service data delete	X(O+E)		X(O+Crew)	X(Some)		X(Own Students)
service data set admin flag	X(O+E)			X(O+CO,XO, ?staff?)		X(Own Students)

Rob:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record	X	X	X	1	1?	X
name	X	X	X	.	.	.
rank	X	.	Non-Flag	.	Non-Flag	.
birthday	X	X	.	.	.	.
lastupdate	3	.	3	3	3	.
joindate	X	.	.	.	.	.
username	2	2	.	.	.	.
password	2	2	.	.	.	.
db restricted	X	.	.	.	.	.
active	X	.	X	X	.	.
lds101	X	.	.	.	.	4
lds201	X	.	.	.	.	4
com101	X	.	.	.	.	4
contact data change	X	X	X	X	.	.
contact data add	X	X	X	X	.	.
contact data delete	X	X	X	X	.	.
contact data show/noshow	X	X	X	.	.	.
service data change	X	.	.	1	.	X
service data add	X	.	X	1	.	4?
service data delete	X	.	.	.	.	.
service data set admin flag	X	.	.	X	.	X

1. ZC's & **POSSIBLY** Branch Heads can only View **& Edit Certain Aspects** the records of Members in their Zone (and Branch). 2. These should never have to be changed. If we really need them changed then they can be done on the raw db level. 3. This will also update when ever any part of a person's record is updated or a CO/XO/ZC verifies they are still active (module to be bulit). 4. These should normally update when a Dean enters data on these three courses on a module to be bulit.

Gary:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record
name
rank
birthday
lastupdate
joindate
username
password
db restricted
active
lds101
lds201
com101
contact data change
contact data add
contact data delete
contact data show/noshow
service data change
service data add
service data delete
service data set admin flag

Logan:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record	X	X	X	1
name	X	X
rank	X		X
birthday	X
lastupdate 2 3
joindate 2
username 2
password	X	X
db restricted	X
active	X
lds101 4	X
lds201 4	X
com101 4	X
contact data change	X	X
contact data add	X	X
contact data delete	X	X
contact data show/noshow	X	X
service data change	X
service data add 4	X		X	X
service data delete	X
service data set admin flag	X

1. ZC's can only view the records of CO's and XO's of cells in their zones.
2. These should never have to be changed. If we really need them changed then they can be done on the raw db level.
3. This will also update when ever any part of a person's record is updated or a CO/XO/ZC verifies they are still active (module to be bulit).
4. These should normally update when a Dean enters data on these three courses on a module to be bulit.

Steve:

• CC/membership head: X = Full access
• for the following: V = Means view only & E = edit+view
  • O = Own Record
  • A = Everyones Record
  • B = Below self in applicable chain of command
  • S = Students Enrolled
  • ? = Don't know/Don't understand field/function
  • 2 = IF possible, otherwise none
  • 3 = Non-Flag

IN GENERAL:

• There needs to be some sort of flags editable by CC to denote membership in branches, zones, any other special units so that the permissions can work.
• Perhaps a special text area ONLY viewable/editable by the CC is needed to record special circumstances such as serious problems, possible ethics violations, and such.

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record (ONLY)	X	VO	VB	VB	VB	VS2
name	X
rank	X		EB3		EB3
birthday	X
lastupdate	X
joindate	X
username	X
password	X	EO
db restricted	X?
active	X
lds101	X					ES2
lds201	X					ES2
com101	X					ES2
contact data change	X	EO	EB	EB
contact data add	X	EO	EB	EB
contact data delete	X	EO
contact data show/noshow	X	EO
service data change	X
service data add	X		EB	EB	EB	ES2
service data delete	X
service data set admin flag	X?

Will:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record
name
rank
birthday
lastupdate
joindate
username
password
db restricted
active
lds101
lds201
com101
contact data change
contact data add
contact data delete
contact data show/noshow
service data change
service data add
service data delete
service data set admin flag