PeopleSoft has delivered two tables PSAUDIT and PSAUDITEXT tables to perform field level audit by enabling the audit through record field properies. Below is the difference bewteen these two tables.
PSAUDIT - Field length of the OLDVALUE and NEWVALUE fields is 65 characters. Field values that are longer than 65 characters are truncated.
PSAUDITEXT - Field length of the PTOLDVALUE and PTNEWVALUE fields is 254 characters.
If you are auditing a field with a field length greater than 65 characters, you should query PSAUDITEXT to ensure that you retrieve the entire field value and not a truncated subset.
PSAUDIT - Field length of the OLDVALUE and NEWVALUE fields is 65 characters. Field values that are longer than 65 characters are truncated.
PSAUDITEXT - Field length of the PTOLDVALUE and PTNEWVALUE fields is 254 characters.
If you are auditing a field with a field length greater than 65 characters, you should query PSAUDITEXT to ensure that you retrieve the entire field value and not a truncated subset.
No comments:
Post a Comment