Field Details

Field name Data type Length Mandatory Comments
USER_ID Int 15 Yes
RESPONSIBILITY_ID Int 15 Yes
RESPONSIBILITY_APPLICATION_ID Int 15 Yes
SECURITY_GROUP_ID Int 15 No
START_DATE Date Time Yes yyyy-mm-dd hh:mi:ss:mmmm
END_DATE Date Time No yyyy-mm-dd hh:mi:ss:mmmm
DESCRIPTION String 240 No
CREATED_BY Int 15 No
CREATION_DATE Date Time No yyyy-mm-dd hh:mi:ss:mmmm
LAST_UPDATED_BY Int 15 No
LAST_UPDATE_DATE Date Time No yyyy-mm-dd hh:mi:ss:mmmm
LAST_UPDATE_LOGIN Int 15 No
IS_ACTIVE String 1 Yes This field will contain values Y/N.
  • Y – Is Active
  • N – Is In-Active