D_OPERATOR_LIST

Version: 1.0

Attribute details

Attribute ID Datatype Data length Nullabe ? Label Description

EMAIL VARCHAR2 200 Y Email Contact email address

FIRSTNAME VARCHAR2 400 Y Contact first name

INSTIT_CODE VARCHAR2 15 N Institution code

INTERNATIONAL_PHONE_PREFIX VARCHAR2 10 Y Phone number prefix

LASTNAME VARCHAR2 400 Y Contact last name

LAST_UPDATE TIMESTAMP(6) WITH TIME ZONE 13 Y Date of last update of report data

LOGIN VARCHAR2 20 Y Login

NATIONAL_PHONE VARCHAR2 20 Y Phone number

OPERATOR_CREATION_DATE TIMESTAMP(6) WITH TIME ZONE 13 Y Creation date of operator (operator = user in a given context (institution, organization, sales))

SUPERVISOR CHAR 1 Y Supervisor of operator

T_OPERATOR_ID NUMBER 22 N Technical identifier of operator

T_ORGANIZATION_ID NUMBER 22 Y Technical identifier of organization

T_STATE VARCHAR2 25 Y Payment state

USER_CREATION_DATE TIMESTAMP(6) WITH TIME ZONE 13 Y Creation date of user

Attribute ID	Datatype	Data length	Nullabe ?	Label	Description
EMAIL	VARCHAR2	200	Y	Email	Contact email address
FIRSTNAME	VARCHAR2	400	Y		Contact first name
INSTIT_CODE	VARCHAR2	15	N		Institution code
INTERNATIONAL_PHONE_PREFIX	VARCHAR2	10	Y		Phone number prefix
LASTNAME	VARCHAR2	400	Y		Contact last name
LAST_UPDATE	TIMESTAMP(6) WITH TIME ZONE	13	Y		Date of last update of report data
LOGIN	VARCHAR2	20	Y		Login
NATIONAL_PHONE	VARCHAR2	20	Y		Phone number
OPERATOR_CREATION_DATE	TIMESTAMP(6) WITH TIME ZONE	13	Y		Creation date of operator (operator = user in a given context (institution, organization, sales))
SUPERVISOR	CHAR	1	Y		Supervisor of operator
T_OPERATOR_ID	NUMBER	22	N		Technical identifier of operator
T_ORGANIZATION_ID	NUMBER	22	Y		Technical identifier of organization
T_STATE	VARCHAR2	25	Y		Payment state
USER_CREATION_DATE	TIMESTAMP(6) WITH TIME ZONE	13	Y		Creation date of user