What Does the CHANGE_TERM Column on the Tables in the SMF Database Represent?
(Doc ID 2421879.1)
Last updated on OCTOBER 10, 2019
Applies to:
Oracle Communications Network Charging and Control - Version 4.3.0 and laterOracle Communications Convergent Charging Controller - Version 6.0.0 and later
Information in this document applies to any platform.
Goal
On all versions of Oracle Communications Network Charging and Control (OCNCC or NCC) and Oracle Communications Convergent Charging Controller (OC3C or 3C), all the tables in the SMF database on the Service Management Server have a CHANGE_TERM column.
For example:
SQL> desc smf_user
Name Null? Type
------------------------------------------------------------------------- -------- -----------------------------------
CHANGE_USER NOT NULL VARCHAR2(30 CHAR)
CHANGE_DATE NOT NULL DATE
CHANGE_TERM NOT NULL VARCHAR2(45 CHAR)
USER_NAME NOT NULL VARCHAR2(30 CHAR)
FULL_NAME NOT NULL VARCHAR2(50 CHAR)
DESCRIPTION VARCHAR2(50 CHAR)
LOGIN_ATTEMPTS NOT NULL NUMBER(1)
LOCK_REASON VARCHAR2(100 CHAR)
PWD_LIFETIME NUMBER(3)
PWD_EXPIRY DATE
JAVA_CONFIG VARCHAR2(200 CHAR)
TEMP_LOCK_TIME NUMBER(4)
TEMP_LOCK_EXPIRY DATE
ACCT_EXPIRY DATE
QOS NOT NULL VARCHAR2(20 CHAR)
SCREENS_USER CHAR(1 CHAR)
Name Null? Type
------------------------------------------------------------------------- -------- -----------------------------------
CHANGE_USER NOT NULL VARCHAR2(30 CHAR)
CHANGE_DATE NOT NULL DATE
CHANGE_TERM NOT NULL VARCHAR2(45 CHAR)
USER_NAME NOT NULL VARCHAR2(30 CHAR)
FULL_NAME NOT NULL VARCHAR2(50 CHAR)
DESCRIPTION VARCHAR2(50 CHAR)
LOGIN_ATTEMPTS NOT NULL NUMBER(1)
LOCK_REASON VARCHAR2(100 CHAR)
PWD_LIFETIME NUMBER(3)
PWD_EXPIRY DATE
JAVA_CONFIG VARCHAR2(200 CHAR)
TEMP_LOCK_TIME NUMBER(4)
TEMP_LOCK_EXPIRY DATE
ACCT_EXPIRY DATE
QOS NOT NULL VARCHAR2(20 CHAR)
SCREENS_USER CHAR(1 CHAR)
What does this CHANGE_TERM column represent?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |