Standard JDE OW file layouts field descriptions

I am an IT auditor and need help. We have the F0092, F0093, F0094 & P98OWSEC tables to test but no field/description layout of what's in each file. Where can I find this info? We have limited time and not much access to the admins. Would like to find online if possible. PLEASE HELP! Thanks to all in advance.

amy3IT,

At least one of those tables has changed over the years. Do you know or can you find out the version of JDE in use? As far as being available online, I'm not sure that it would be. But given the version of JDE, a JDEList member may be able to provide the table structures and field and table descriptions you require.

If you have Fast Path in 8.12 run job: P980011. You should find more than enough information...

Amy,

The System admin guides should have this info ,but here is a quick run down with simple descriptions

F0092 - User & Role Table (The master table which defines users and roles , main field is ULUSER)

F0093 - Environment Access (Tables specifies the environments that a user or role can access.

Main Relationship F0093.LLUSER = F0092.ULUSER)

F0094 - Enviornment Master - From an Audit standpoint not sure if you will have much use for this table

F98OWSEC - User Sign on Security ( Tables lists the status of the user , password attempts , expritation properties etc , the actual password for the user (enrypted) , the system account they use to access the DB)

Main relationship - F98OWSEC.SCUSER = F0092.ULUSER

And then there is the F00950 which you have not mentioned , this tables lists what objects a user or role has access to , and what kind of access.

Main relationship F00950.FSUSER = F0092.ULUSER

Hope this helps you get started at least

[ QUOTE ]
I am an IT auditor and need help. We have the F0092, F0093, F0094 & P98OWSEC tables to test but no field/description layout of what's in each file. Where can I find this info? We have limited time and not much access to the admins. Would like to find online if possible. PLEASE HELP! Thanks to all in advance.

[/ QUOTE ]

Not sure if this will help but it will give you column descriptions for the tables you mentioned:

<font class="small">Code:</font><hr /><pre>

SELECT JDE_DV812.DV812.F98711.TDOBNM as 'Table Name',
JDE_DV812.DV812.F98711.TDSQLC as 'SQL Column Name',
JDE812.DD812.F9203.FRDTAI as 'Data Dictionary Name',
JDE812.DD812.F9203.FRDSCA as 'Column Description'
FROM JDE_DV812.DV812.F98711
JOIN JDE812.DD812.F9203
ON JDE_DV812.DV812.F98711.TDOBND = JDE812.DD812.F9203.FRDTAI
WHERE JDE_DV812.DV812.F98711.TDOBNM in ('F0092', 'F0093', 'F0094', 'F98OWSEC')
and JDE812.DD812.F9203.FRDSCC ! = '*SAME' and JDE812.DD812.F9203.FRDSCC ! = ''
ORDER by JDE_DV812.DV812.F98711.TDOBNM


</pre><hr />

This is a very rough script I just threw together and there may be more than one data dictionary description for a given column, depending on what form the field is used on. Most are similar names though so it shouldn't be a big deal.

Also, from your use of the term 'file' to refer to a table I suspect that you may be on iSeries so have one of your operators change the syntax to DB2 if necessary.

Can you help me with coding this for OneWorld Xe? My F93711 table is empty, so I wonder if I should be pointing to another table. Any help is appreciated.