Output Stamping Attributes

The following stamping attributes can be used (in the data dictionary only) to indicate that certain fields in file definitions should be automatically "stamped" during INSERT and/or UPDATE operations:

User and Job Stamping Attributes

Attribute

Description / Comments

A

P

S

USRC

When a field with this attribute is in a file it should always contain the user profile name of the user that created the record.

A user profile name may be up to 256 characters in length if *LONG_USER_AUDIT is enabled when the file is compiled, otherwise it may be up to 10 characters in length.
If *LONG_USER_AUDIT is enabled, the user name will be the audit user (up to 256 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current authenticated user name is used if available, otherwise the current user name is used.
If *LONG_USER_AUDIT is not enabled then the user name will be the audit user (up to 10 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current user name is used.

If running a function through SuperServer, USRC contains the user name used to connect to the server. Refer to USCR Examples to see how this name can be used.

Y

N

N

USRU

When a field with this attribute is in a file, it should always contain the user profile name of the user that last updated the record or be blank, if the record has never been updated.

A user profile name may be up to 256 characters in length if *LONG_USER_AUDIT is enabled when the file is compiled, otherwise it may be up to 10 characters in length.
If *LONG_USER_AUDIT is enabled then the user name will be the audit user (up to 256 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current authenticated user name is used if available, otherwise the current user name is used.
If *LONG_USER_AUDIT is not enabled then the user name will be the audit user (up to 10 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current user name is used.

The user name will be the audit user if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current user name is used.

Y

N

N

USRX

When a field with this attribute is in a file it should always contain the user profile name of the user that either created or last updated the record.

A user profile name may be up to 256 characters in length if *LONG_USER_AUDIT is enabled when the file is compiled, otherwise it may be up to 10 characters in length.
If *LONG_USER_AUDIT is enabled then the user name will be the audit user (up to 256 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current authenticated user name is used if available, otherwise the current user name is used.
If *LONG_USER_AUDIT is not enabled then the user name will be the audit user (up to 10 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current user name is used.

The user name will be the audit user if the SET_SESSION_VALUE  USER_AUDIT has been set, otherwise the current user name is used.

Y

N

N

JNMC

When a field with this attribute is in a file it should always contain the name of the job that was used to create the record. A job name may be up to 10 characters in length

Y

N

N

JNMU

When a field with this attribute is in a file it should always contain the name of the job that was last used to update the record, or, be blank if the record has never been updated.

Y

N

N

JNMX

When a field with this attribute is in a file it should always contain the name of the job that was used to either create or last update the record.

Y

N

N

JNRC

When a field with this attribute is in a file it should always contain the number of the job that was used to create the record. A job number may be up to 6 characters in length

Y

N

N

JNRU

When a field with this attribute is in a file it should always contain the number of the job that was last used to update the record, or, be blank if the record has never been updated.

Y

N

N

JNRX

When a field with this attribute is in a file it should always contain the number of the job that was used to either create or last update the record.

Y

N

N

 

Time and/or Date Stamping Attributes

Attribute

Description / Comments

A

P

S

TIMC

When a field with this attribute is in a file it should always contain the time that the record was created. All time stamps are 6 digits long in the format HHMMSS.

Y

Y

Y

TIMU

When a field with this attribute is in a file it should always contain the time that the record was last updated, or, contain zeroes if the record has never been updated.

Y

Y

Y

TIMX

When a field with this attribute is in a file it should always contain the time that the record was created or the time that it was last updated.

Y

Y

Y

DATC

When a field with this attribute is in a file it should always contain the date that the record was created. All DAT date stamps are 6 digits long in system date format.

Y

Y

Y

DATU

When a field with this attribute is in a file it should always contain the date that the record was last updated, or, contain zeroes if the record has never been updated.

Y

Y

Y

DATX

When a field with this attribute is in a file it should always contain the date that the record was created or the date that it was last updated.

Y

Y

Y

TDSC

When a field with this attribute is in a file it  should always contain the time/date that the record was created. All TDS time/date stamps are 12 digits long in the format HHMMSSDDDDDD where HHMMSS is the time and DDDDDD is the date in system date format.

Y

Y

Y

TDSU

When a field with this attribute is in a file it should always contain the time/date that the record was last updated, or, contain zeroes if the record has never been updated.

Y

Y

Y

TDSX

When a field with this attribute is in a file it should always contain the time/date that the record was created or the time/date that it was last updated.

Y

Y

Y

CDTC

When a field with this attribute is in a file it should always contain the date the record was created. All CDT date stamps are 8 digits long in system date format.

Y

Y

Y

CDTU

When a field with this attribute is in a file it should always contain the 8 digit date that the record was last updated, or contain zeroes if the record has never been updated.

Y

Y

Y

CDTX

When a field with this attribute is in a file it should always contain the 8 digit date that the record was created or last updated.

Y

Y

Y

TCDC

When a field with this attribute is in a file it should always contain the time/date the record was created. All TCD time/date stamps are 14 digits in format HHMMSSDDDDDDDD where HHMMSS is the time and DDDDDDDD is the date in system format.

Y

Y

Y

TCDU

When a field with this attribute is in a file it should always contain the time/date that the record was last updated, or contain zeroes if the record has never been updated.

Y

Y

Y

TCDX

When a field with this attribute is in a file it should always contain the time/date that the record was created or last updated.

Y

Y

Y

YMDC

When a field with this attribute is in a file it should always contain the date that the record was created. All YMD dates are 6 digits in YYMMDD format.

Y

Y

Y

YMDU

When a field with this attribute is in a file it should always contain the date that the record was last updated, or contain zeroes if the record has never been updated.

Y

Y

Y

YMDX

When a field with this attribute is in a file it should always contain the date the record was created or last updated.

Y

Y

Y

TYDC

When a field with this attribute is in a file it should always contain the time/date that the record was created. All TYD time/dates are 12 digits in HHMMSSYYMMDD format.

Y

Y

Y

TYDU

When a field with this attribute is in a file it should always contain the time/date that the record was last updated, or contain zeroes if the record has never been updated.

Y

Y

Y

TYDX

When a field with this attribute is in a file it should always contain the time/date that the record was created or last updated.

Y

Y

Y

CYDC

When a field with this attribute is in a file it should always contain the date that the record was created. All CYD dates are 8 digits in YYYYMMDD format.

Y

Y

Y

CYDU

When a field with this attribute is in a file it should always contain the date that the record was last updated, or contain zeroes if the record has never been updated.

Y

Y

Y

CYDX

When a field with this attribute is in file it should always contain the date that the record was created or last updated.

Y

Y

Y

 

Process and Function Stamping Attributes

Attribute

Description / Comments

A

P

S

FUNC

When a field with this attribute is in a file it should always contain the name of the RDML function that was used to create the record. A function name may be up to 7 characters in length.

Y

N

N

FUNU

When a field with this attribute is in a file it should always contain the name of the RDML function that was last used to update the record or be blank if the record has never been updated.

Y

N

N

FUNX

When a field with this attribute is in a file it should always contain the name of the RDML function that was used to either create or last update the record.

Y

N

N

PROC

When a field with this attribute is in a file it should always contain the name of the process that was used to create the record. A process name may be up to 10 characters in length.

Y

N

N

PROU

When a field with this attribute is in a file it should always contain the name of the process that was last used to update the record, or be blank, if the record has never been updated.

Y

N

N

PROX

When a field with this attribute is in a file it should always contain the name of the process that was used to either create or last update the record.

Y

N

N