You are here: LANSA for i User Guide > 2. Fields > 2.3 Create New Field Definitions > Output Stamping Attributes
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