Difference between revisions of "Myclearance"

From SPGC Document Wiki
Jump to: navigation, search
(→‎mod_sec_accs)
Line 95: Line 95:
 
|}
 
|}
  
−
==mod_sec_accs==
+
==recid==
 
{| class="wikitable" \
 
{| class="wikitable" \
−
!colspan="7" | mod_sec_accs
+
!colspan="7" | recid
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name
Line 106: Line 106:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|Company
+
|recid
−
|varchar
+
|int
−
|255
+
|20
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|-
 
|-
−
|Department
+
|MSA_USER
 
|varchar
 
|varchar
−
|255
+
|50
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
−
|-
 
−
|Emp#
 
−
|varchar
 
−
|255
 
−
|No
 
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|Employee Name
+
|MSA_SYS
 
|varchar
 
|varchar
−
|255
+
|2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|Position
+
|MSA_MODULE
 
|varchar
 
|varchar
−
|255
+
|4
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|Joblelvel
+
|MSA_SMODULE
 
|varchar
 
|varchar
−
|255
+
|5
−
|Yes
+
 
|No
 
|No
 
|No
 
|No
−
|-
 
−
|User IDs
 
−
|varchar
 
−
|25
 
−
|No
 
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|lname
+
|MSA_ENCDTE
−
|varchar
+
|datetime
−
|50
+
|0
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
−
|-
 
−
|fname
 
−
|varchar
 
−
|50
 
−
|No
 
−
|Yes
 
−
|No
 
−
|-
 
−
|mname
 
−
|varchar
 
−
|50
 
−
|No
 
−
|Yes
 
−
|No
 
−
|-
 
−
|email
 
−
|varchar
 
−
|50
 
−
|No
 
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|fullname
+
|MSA_MRK
 
|varchar
 
|varchar
−
|150
+
|1
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 17:20, 4 August 2016

executive_users

executive_users
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Company varchar 255 Yes Yes Yes
Department varchar 255 No Yes No
Emp# varchar 255 No Yes No
Employee Name varchar 255 No No No
Position varchar 255 No No No
Joblelvel varchar 255 Yes No No
User IDs varchar 25 No Yes No
lname varchar 50 No Yes No
fname varchar 50 No Yes No
mname varchar 50 No Yes No
email varchar 50 No Yes No
fullname varchar 150 No No No

recid

recid
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
MSA_USER varchar 50 No No No
MSA_SYS varchar 2 No No No
MSA_MODULE varchar 4 No No No
MSA_SMODULE varchar 5 No No No
MSA_ENCDTE datetime 0 No No No
MSA_MRK varchar 1 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myclearance&oldid=2503"