Myclearance

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

sec_codes

sec_codes
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	20	Yes	Yes	Yes
SEC_CODE	varchar	25	No	No	No
SEC_DATE	datetime	3	No	No	No
SEC_USER	varchar	25	No	No	No
SEC_MARK	varchar	1	No	No	No

sppe_combined_ids

sppe_combined_ids
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	20	Yes	Yes	Yes
email	varchar	50	No	No	No
lname	varchar	50	No	No	No
fname	varchar	50	No	No	No
mname	varchar	50	No	No	No
fullname	varchar	150	No	No	No

store_users

store_users
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	20	Yes	Yes	Yes
SEC_CODE	varchar	25	No	No	No
SEC_DATE	datetime	3	No	No	No
SEC_USER	varchar	25	No	No	No
SEC_MARK	varchar	1	No	No	No