UDF File Relationships

ADMUDCAT

This holds the data from the first page of the UDF set up screen.

The data being keyed on:

a) Variation_id – Company

b) Module_id – Payroll or Personnel

c) Entity_id – File

d) Cat_seq_id – Internal sequence number

 

 

ADMUDDEF

This holds the data from the second page of the UDF set up screen; one record per line.

The data being keyed on:

a) Cat_seq_id – Sequence number from admudcat table

b) Ud_seq_id – Internal sequence number for this file

 

 

ADMUDDAT

This holds the actual UDF data itself.

The data being keyed on:

a) Cat_seq_id – Sequence number from admudcat table

b) Code_id – Employee number, if linked to pnlempmst. Otherwise seq_id from table such as pnlemphst

c) Ud_seq_id – Sequence number from admuddef table.