Computer Operations/sandbox

Revision as of 00:22, 14 November 2007 (view source) Watchdog (Talk | contribs) m		Latest revision as of 05:55, 31 December 2007 (view source) Watchdog (Talk | contribs) m (→‎Steve:)
(13 intermediate revisions by one user not shown)
Line 1:		Line 1:
−	----	+
−	Sam:	+	==Sam:==
	{| border=1		{| border=1
	|		|
Line 182:		Line 182:
−	----	+
−	CD:	+	==CD:===
		+	<br><br><br>
		+	O-Own Record<br> E-Everyones <br>This figures in after 'viewing record' of editing privilages in applicable areas.Let me know if more info is needed.<br><br><br>
	{| border=1		{| border=1
	|		|
Line 195:		Line 197:
	|-		|-
	|view record		|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		|name
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|rank		|rank
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
−	|	+	|X(O, ?staff?)
−	|	+	|X(O)
	|-		|-
	|birthday		|birthday
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|lastupdate		|lastupdate
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|joindate		|joindate
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
−	|	+	|X(O, ?staff?)
−	|	+	|X(O)
	|-		|-
	|username		|username
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|password		|password
−	|	+	|X(O+?E?)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|db restricted		|db restricted
−	|	+	|X(O+E)
	|		|
	|		|
Line 267:		Line 269:
	|-		|-
	|active		|active
		+	|X(O+E)
	|		|
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
−	|	+
	|		|
	|		|
	|-		|-
	|lds101		|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		|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		|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		|contact data change
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
	|		|
	|		|
Line 308:		Line 310:
	|		|
	contact data add		contact data add
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
	|		|
	|		|
	|-		|-
	|contact data delete		|contact data delete
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
−	|	+
	|		|
	|-		|-
	|contact data show/noshow		|contact data show/noshow
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
	|		|
	|		|
	|-		|-
	|service data change		|service data change
		+	|X(O+E)
	|		|
	|		|
		+	|X-Some
	|		|
−	|	+	|X(Own Students)
−	|	+
−	|	+
	|-		|-
	|service data add		|service data add
Line 345:		Line 346:
	|		|
	|		|
−	|	+	|X(Own Students)
	|-		|-
	|service data delete		|service data delete
		+	|X(O+E)
	|		|
		+	|X(O+Crew)
		+	|X(Some)
	|		|
−	|	+	|X(Own Students)
−	|	+
−	|	+
−	|	+
	|-		|-
	|service data set admin flag		|service data set admin flag
		+	|X(O+E)
	|		|
	|		|
		+	|X(O+CO,XO, ?staff?)
	|		|
−	|	+	|X(Own Students)
−	|	+
−	|	+
	|}		|}
−		+	==Rob:==
−	----	+
−	Rob:	+
	{| border=1		{| border=1
	|		|
Line 378:		Line 377:
	|-		|-
	|view record		|view record
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	| 1
−	|	+	| 1?
−	|	+	| X
	|-		|-
	|name		|name
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|rank		|rank
−	|	+	| X
−	|	+	| .
−	|	+	| Non-Flag
−	|	+	| .
−	|	+	| Non-Flag
−	|	+	| .
	|-		|-
	|birthday		|birthday
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|lastupdate		|lastupdate
−	|	+	| 3
−	|	+	| .
−	|	+	| 3
−	|	+	| 3
−	|	+	| 3
−	|	+	|.
	|-		|-
	|joindate		|joindate
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|username		|username
−	|	+	| 2
−	|	+	| 2
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|password		|password
−	|	+	| 2
−	|	+	| 2
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|db restricted		|db restricted
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|active		|active
−	|	+	| X
−	|	+	| .
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
	|-		|-
	|lds101		|lds101
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	| 4
	|-		|-
	|lds201		|lds201
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	| 4
	|-		|-
	|com101		|com101
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	| 4
	|-		|-
	|contact data change		|contact data change
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
	|-		|-
	|		|
	contact data add		contact data add
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
	|-		|-
	|contact data delete		|contact data delete
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
	|-		|-
	|contact data show/noshow		|contact data show/noshow
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|service data change		|service data change
−	|	+	| X
−	|	+	| .
−	|	+	| .
−	|	+	| 1
−	|	+	|.
−	|	+	| X
	|-		|-
	|service data add		|service data add
−	|	+	| X
−	|	+	| .
−	|	+	| X
−	|	+	| 1
−	|	+	| .
−	|	+	| 4?
	|-		|-
	|service data delete		|service data delete
−	|	+	| X
−	|	+	| .
−	|	+	| .
−	|	+	| .
−	|	+	|.
−	|	+	| .
	|-		|-
	|service data set admin flag		|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:==
−	----	+
−		+
−	Gary:	+
	{| border=1		{| border=1
	|		|
Line 732:		Line 732:
−	----
−	Logan:	+
		+	==Logan:==
	{| border=1		{| border=1
	|		|
Line 746:		Line 746:
	|-		|-
	|view record		|view record
−	|	+	|X
−	|	+	|X
−	|	+	|X
−	|	+	|1
	|		|
	|		|
	|-		|-
	|name		|name
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 762:		Line 762:
	|-		|-
	|rank		|rank
		+	|X
	|		|
−	|	+	|X
−	|	+
	|		|
	|		|
Line 770:		Line 770:
	|-		|-
	|birthday		|birthday
−	|	+	|X
	|		|
	|		|
Line 777:		Line 777:
	|		|
	|-		|-
−	|lastupdate	+	|lastupdate 2 3
	|		|
	|		|
Line 785:		Line 785:
	|		|
	|-		|-
−	|joindate	+	|joindate 2
	|		|
	|		|
Line 793:		Line 793:
	|		|
	|-		|-
−	|username	+	|username 2
	|		|
	|		|
Line 802:		Line 802:
	|-		|-
	|password		|password
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 810:		Line 810:
	|-		|-
	|db restricted		|db restricted
−	|	+	|X
	|		|
	|		|
Line 818:		Line 818:
	|-		|-
	|active		|active
−	|	+	|X
	|		|
	|		|
Line 825:		Line 825:
	|		|
	|-		|-
−	|lds101	+	|lds101 4
−	|	+	|X
	|		|
	|		|
Line 833:		Line 833:
	|		|
	|-		|-
−	|lds201	+	|lds201 4
−	|	+	|X
	|		|
	|		|
Line 841:		Line 841:
	|		|
	|-		|-
−	|com101	+	|com101 4
−	|	+	|X
	|		|
	|		|
Line 850:		Line 850:
	|-		|-
	|contact data change		|contact data change
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 859:		Line 859:
	|		|
	contact data add		contact data add
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 867:		Line 867:
	|-		|-
	|contact data delete		|contact data delete
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 875:		Line 875:
	|-		|-
	|contact data show/noshow		|contact data show/noshow
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 883:		Line 883:
	|-		|-
	|service data change		|service data change
−	|	+	|X
	|		|
	|		|
Line 890:		Line 890:
	|		|
	|-		|-
−	|service data add	+	|service data add 4
−	|	+	|X
−	|	+
−	|	+
	|		|
		+	|X
		+	|X
	|		|
	|		|
	|-		|-
	|service data delete		|service data delete
−	|	+	|X
	|		|
	|		|
Line 907:		Line 907:
	|-		|-
	|service data set admin flag		|service data set admin flag
−	|	+	|X
	|		|
	|		|
Line 915:		Line 915:
	|}		|}
−	----	+	1. ZC's can only view the records of CO's and XO's of cells in their zones.<br>
−	Steve:	+	2. These should never have to be changed.  If we really need them changed then they can be done on the raw db level.<br>
		+	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).<br>
		+	4. These should normally update when a Dean enters data on these three courses on a module to be bulit.<br>
		+
		+	==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.
		+
		+
	{| border=1		{| border=1
	|		|
Line 927:		Line 947:
	|dean		|dean
	|-		|-
−	|view record	+	|view record (ONLY)
−	|	+	|X
−	|	+	|VO
−	|	+	|VB
−	|	+	|VB
−	|	+	|VB
−	|	+	|VS2
	|-		|-
	|name		|name
−	|	+	|X
	|		|
	|		|
Line 944:		Line 964:
	|-		|-
	|rank		|rank
		+	|X
	|		|
		+	|EB3
	|		|
−	|	+	|EB3
−	|	+
−	|	+
	|		|
	|-		|-
	|birthday		|birthday
−	|	+	|X
	|		|
	|		|
Line 960:		Line 980:
	|-		|-
	|lastupdate		|lastupdate
−	|	+	|X
	|		|
	|		|
Line 968:		Line 988:
	|-		|-
	|joindate		|joindate
−	|	+	|X
	|		|
	|		|
Line 976:		Line 996:
	|-		|-
	|username		|username
−	|	+	|X
	|		|
	|		|
Line 984:		Line 1,004:
	|-		|-
	|password		|password
−	|	+	|X
−	|	+	|EO
	|		|
	|		|
Line 992:		Line 1,012:
	|-		|-
	|db restricted		|db restricted
−	|	+	|X?
	|		|
	|		|
Line 1,000:		Line 1,020:
	|-		|-
	|active		|active
−	|	+	|X
	|		|
	|		|
Line 1,008:		Line 1,028:
	|-		|-
	|lds101		|lds101
		+	|X
	|		|
	|		|
	|		|
	|		|
−	|	+	|ES2
−	|	+
	|-		|-
	|lds201		|lds201
		+	|X
	|		|
	|		|
	|		|
	|		|
−	|	+	|ES2
−	|	+
	|-		|-
	|com101		|com101
		+	|X
	|		|
	|		|
	|		|
	|		|
−	|	+	|ES2
−	|	+
	|-		|-
	|contact data change		|contact data change
−	|	+	|X
−	|	+	|EO
−	|	+	|EB
−	|	+	|EB
	|		|
	|		|
Line 1,041:		Line 1,061:
	|		|
	contact data add		contact data add
−	|	+	|X
−	|	+	|EO
−	|	+	|EB
−	|	+	|EB
	|		|
	|		|
	|-		|-
	|contact data delete		|contact data delete
−	|	+	|X
−	|	+	|EO
	|		|
	|		|
Line 1,057:		Line 1,077:
	|-		|-
	|contact data show/noshow		|contact data show/noshow
−	|	+	|X
−	|	+	|EO
	|		|
	|		|
Line 1,065:		Line 1,085:
	|-		|-
	|service data change		|service data change
−	|	+	|X
	|		|
	|		|
Line 1,073:		Line 1,093:
	|-		|-
	|service data add		|service data add
		+	|X
	|		|
−	|	+	|EB
−	|	+	|EB
−	|	+	|EB
−	|	+	|ES2
−	|	+
	|-		|-
	|service data delete		|service data delete
−	|	+	|X
	|		|
	|		|
Line 1,089:		Line 1,109:
	|-		|-
	|service data set admin flag		|service data set admin flag
−	|	+	|X?
	|		|
	|		|
Line 1,097:		Line 1,117:
	|}		|}
−	----	+	==Will:==
−	Will:	+
	{| border=1		{| border=1
	|		|

---

Latest revision as of 05:55, 31 December 2007

Contents 1 Sam: 2 CD:= 3 Rob: 4 Gary: 5 Logan: 6 Steve: 7 Will:

[edit] 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

[edit] 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)

[edit] 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.

[edit] 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

[edit] 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.

[edit] 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?

[edit] 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