The file to be updated is pnlempdoc.
|Trn_seq_id||Sequence number within entity_id file (unless its pnlempmst when leave blank)|
- Document Type – would need some way of stripping the last three characters, unless all types are .doc. (Note: or may be able to go back in via sql and sort it out).
- If linking in to table other than the pnlempmst, would need to know the sequence number to which the record is being linked.