scim_im

Tables (13)

SCIM_ADMIN

  • ADMINID — VARCHAR2(50 CHAR)
  • ADMINNAME — VARCHAR2(50 CHAR)
  • ADMINTYPE — VARCHAR2(50 CHAR)
  • PASSWD — VARCHAR2(256 CHAR)
  • LOGINTIME — DATE
  • PWEXPIRETIME — DATE

SCIM_AUDIT

  • WORKID — VARCHAR2(50 CHAR)
  • ADMINID — VARCHAR2(50 CHAR)
  • USERID — VARCHAR2(50 CHAR)
  • SOURCESYSTEM — VARCHAR2(50 CHAR)
  • DIRECTSYSTEM — VARCHAR2(50 CHAR)
  • METHOD — VARCHAR2(50 CHAR)
  • RESULT — VARCHAR2(50 CHAR)
  • DETAIL — VARCHAR2(256 CHAR)
  • WORKDATE — DATE

SCIM_DATA_DEFINITION

  • DATAID — VARCHAR2(50 CHAR)
  • DATANAME — VARCHAR2(50 CHAR)
  • DATATYPE — VARCHAR2(50 CHAR)
  • DATASIZE — VARCHAR2(50 CHAR)
  • NULLABLE — VARCHAR2(50 CHAR)
  • DATADEFAULT — VARCHAR2(50 CHAR)
  • DESCRIPTION — VARCHAR2(50 CHAR)

SCIM_SCHEDULER

  • SCHEDULERID — VARCHAR2(50 CHAR)
  • SCHEDULERNAME — VARCHAR2(50 CHAR)
  • SCHEDULERTYPE — VARCHAR2(50 CHAR)
  • SCHEDULERDESC — VARCHAR2(50 CHAR)
  • JOBCLASS — VARCHAR2(50 CHAR)
  • TRIGGERTYPE — VARCHAR2(50 CHAR)
  • DAYOFMONTH — NUMBER(10,0)
  • DAYOFWEEK — NUMBER(10,0)
  • HOUROFDAY — NUMBER(10,0)
  • MINUTEOFHOUR — NUMBER(10,0)
  • EXCUTESYSTEMID — VARCHAR2(50 CHAR)
  • SOURCESYSTEMID — VARCHAR2(50 CHAR)
  • TARGETSYSTEMID — VARCHAR2(50 CHAR)
  • LASTEXECUTEDATE — DATE

SCIM_SCHEDULER_HISTORY

  • SCHEDULERID — VARCHAR2(50 CHAR)
  • WORKID — VARCHAR2(50 CHAR)
  • REQPOST — NUMBER(10,0)
  • REQPUT — NUMBER(10,0)
  • REQDELETE — NUMBER(10,0)
  • REQPATCH — NUMBER(10,0)
  • RESPOST — NUMBER(10,0)
  • RESPUT — NUMBER(10,0)
  • RESDELETE — NUMBER(10,0)
  • RESPATCH — NUMBER(10,0)
  • WORKDATE — DATE

SCIM_SYSTEM

  • SYSTEMID — VARCHAR2(50 CHAR)
  • SYSTEMNAME — VARCHAR2(50 CHAR)
  • SYSTEMDESC — VARCHAR2(50 CHAR)
  • SYSTEMURL — VARCHAR2(50 CHAR)
  • SYSTEMTYPE — VARCHAR2(50 CHAR)

SCIM_SYSTEM_ADMIN

  • USERID — VARCHAR2(50 CHAR)
  • SYSTEMID — VARCHAR2(50 CHAR)
  • ROLE — VARCHAR2(50 CHAR)

SCIM_SYSTEM_COLUMN

  • SYSTEMID — VARCHAR2(50 CHAR)
  • COLUMNNAME — VARCHAR2(50 CHAR)
  • DISPLAYNAME — VARCHAR2(50 CHAR)
  • DATATYPE — VARCHAR2(50 CHAR)
  • DATASIZE — NUMBER(10,0)
  • ALLOWNULL — NUMBER(10,0)
  • DEFAULTVALUE — VARCHAR2(50 CHAR)
  • COLUMNCOMMENT — VARCHAR2(50 CHAR)
  • MAPPINGCOLUMN — VARCHAR2(50 CHAR)

SCIM_SYSTEM_DATA_DEFINITION

  • SYSTEMID — VARCHAR2(50 CHAR)
  • DATAID — VARCHAR2(50 CHAR)
  • DATANAME — VARCHAR2(50 CHAR)
  • DATATYPE — VARCHAR2(50 CHAR)
  • DATASIZE — VARCHAR2(50 CHAR)
  • NULLABLE — VARCHAR2(50 CHAR)
  • DATADEFAULT — VARCHAR2(50 CHAR)
  • DESCRIPTION — VARCHAR2(50 CHAR)

SCIM_SYSTEM_USER

  • SYSTEMID — VARCHAR2(50 CHAR)
  • USERID — VARCHAR2(50 CHAR)
  • EXTERNALID — VARCHAR2(50 CHAR)
  • USERNAME — VARCHAR2(50 CHAR)
  • PASSWORD — VARCHAR2(50 CHAR)
  • USERTYPE — VARCHAR2(50 CHAR)
  • ACTIVE — NUMBER(10,0)
  • CREATEDATE — DATE
  • MODIFYDATE — DATE
  • LASTACCESSDATE — DATE

SCIM_SYSTEM_USER_PROFILE

  • SYSTEMID — VARCHAR2(50 CHAR)
  • USERID — VARCHAR2(50 CHAR)
  • PKEY — VARCHAR2(50 CHAR)
  • PVALUE — VARCHAR2(50 CHAR)
  • PVER — VARCHAR2(50 CHAR)

SCIM_USER

  • USERID — VARCHAR2(50 CHAR)
  • USERNAME — VARCHAR2(50 CHAR)
  • PASSWORD — VARCHAR2(50 CHAR)
  • USERTYPE — VARCHAR2(50 CHAR)
  • ACTIVE — NUMBER(10,0)
  • CREATEDATE — DATE
  • MODIFYDATE — DATE

SCIM_USER_PROFILE

  • USERID — VARCHAR2(50 CHAR)
  • PKEY — VARCHAR2(50 CHAR)
  • PVALUE — VARCHAR2(50 CHAR)
  • PVER — VARCHAR2(50 CHAR)