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)