RHN_CONTACT_MONITORING
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| RECID | NUMBER(38) | N | NO | NO | NO | |
| CUSTOMER_ID | NUMBER(38) | N | NO | NO | NO | |
| CONTACT_LAST_NAME | VARCHAR2(128) | N | YES | YES | YES | |
| CONTACT_FIRST_NAME | VARCHAR2(128) | N | YES | YES | YES | |
| EMAIL_ADDRESS | VARCHAR2(4000) | Y | NO | NO | NO | |
| USERNAME | VARCHAR2(64) | N | NO | NO | NO | |
| PASSWORD | VARCHAR2(38) | N | NO | NO | NO | |
| SCHEDULE_ID | NUMBER(38) | Y | NO | NO | NO | |
| PREFERRED_TIME_ZONE | CHAR(3) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select u.id as recid,
u.org_id as customer_id,
wupi.last_name as contact_last_name,
wupi.first_names as contact_first_name,
rhn_user.find_mailable_address(u.id)
as email_address,
u.login as username,
u.password as password,
1 as schedule_id,
'GMT' as preferred_time_zone
from
web_user_personal_info wupi,
web_contact u
where u.id = wupi.web_user_id