Difference between revisions of "Myclearance"

From SPGC Document Wiki
Jump to: navigation, search
(→‎rcmodaccs)
(→‎rcuser_accounts)
Line 223: Line 223:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|recid
+
|recID
 
|int
 
|int
−
|20
+
|10
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|-
 
|-
−
|MSA_USER
+
|Username
 
|varchar
 
|varchar
 
|50
 
|50
 
|No
 
|No
−
|No
+
|Yes
 
|No
 
|No
 
|-
 
|-
−
|MSA_SYS
+
|Surname
 
|varchar
 
|varchar
−
|2
+
|30
−
|No
+
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
−
|MSA_MODULE
+
|Firstname
 
|varchar
 
|varchar
−
|4
+
|30
−
|No
+
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
−
|MSA_SMODULE
+
|Midname
 
|varchar
 
|varchar
−
|5
+
|30
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|MSA_ENCDTE
+
|User_Password
−
|datetime
+
|longtext
 
|0
 
|0
 
|No
 
|No
−
|No
+
|Yes
 
|No
 
|No
 
|-
 
|-
−
|MSA_MRK
+
|User_Type
 
|varchar
 
|varchar
−
|1
+
|15
−
|No
+
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 
|}
 
|}

Revision as of 18:16, 4 August 2016

auditlogs

auditlogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
LOG_USER varchar 25 No Yes No
LOG_MODULE varchar 50 No Yes No
LOG_KEYREC varchar 50 No No No
LOG_TBL varchar 50 No No No
LOG_DATE datetime 0 Yes No No
LOG_ENUMB varchar 25 No Yes No
LOG_MODFLD longtext 0 No Yes No
LOG_FIELD varchar 25 No Yes No
LOG_OLDVAL varchar 40 No Yes No
LOG_NEWVAL varchar 40 No Yes No
LOG_SQLEXEC longtext 0 No No No
LOG_CHANGE varchar 25 No Yes No
LOG_IPADDR varchar 25 No Yes No
LOG_PRNT varchar 25 No Yes No

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

rcuser_accounts

rcuser_accounts
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recID int 10 Yes Yes Yes
Username varchar 50 No Yes No
Surname varchar 30 No Yes No
Firstname varchar 30 No Yes No
Midname varchar 30 No No No
User_Password longtext 0 No Yes No
User_Type varchar 15 No Yes No

myctr

myctr
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
CTR_YEAR varchar 4 No No No
EMP_NO varchar 15 No No No
CLR_NO varchar 15 No No No
CTR_NO varchar 15 No No No

pmmdept

pmmdept
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
DEPDPCD varchar 10 No No No
DEPCPCD varchar 1 No No No
DEPNAME varchar 35 No No No
DEPINCO varchar 2 No No No
DEPSLWG varchar 8 No No No
DEPSSSM varchar 8 No No No
DEPABBR varchar 5 No Yes No
DEPCOCD varchar 1 No No No
DEPFLAG varchar 1 No No No
DEPBONS varchar 8 No No No
DEPBENE varchar 8 No No No
DEPOCDE varchar 3 No No No

pmmloca

pmmloca
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
LOCCODE varchar 3 No No No
LOCDESC varchar 20 No No No

pmmposn

pmmposn
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
POSPSCD varchar 3 No No No
POSDESC varchar 35 No No No
POSJLCD varchar 3 No No No
POSJOSC longtext 0 No No No
OCODE varchar 3 No No No

postfix_alias

postfix_alias
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
alias varchar 128 No Yes No
destination varchar 128 No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myclearance&oldid=2520"