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 |