Company and Agent Owners Export Data Definition (COMPANY_AGENT_OWNERS)

This Company and Agent Owners Export provides users with the opportunity to see all current Primary and Secondary Owners of each Company and Travel Agent Profile on-demand. The export can also be used to import all required information into a third party system. This export can be manually run by selecting Miscellaneous>File Export or Configuration>External>Export Files. The file transfer from OPERA to the database is completed by using the OPERA OXI_HUB Interface, with an HTTP address that is setup for the actual export file itself (see Export Files for details).

File Type

COMPANY_AGENT_OWNERS

Views Used by This Export

EXPORT_COMPANY_AGENT_OWNERS.VW

Pre-Export Procedure

<None>

Post Export Procedure

<None>

File Name Formula

'CAO_'||to_char(pms_p.business_date,'MMDDYY')||'EXP'

File Extension Formula

'TXT'

Data Export Columns

Column Name	Length	Align	Data Type	Prompt	Default
RECORD_TYPE	Variable	L	VARCHAR2	N	0
SOURCE_SYSTEM (OPERA)	Variable	L	VARCHAR2	N
BUSINESS_DATE	Variable	L	VARCHAR2	N
PROFILE_ID (Name ID)	Variable	L	VARCHAR2	N
UDFC40	Variable	L	VARCHAR2	N
PROFILE_NAME (Company / Agent Name)	Variable	L	VARCHAR2	N
OWNER_CODE	Variable	L	VARCHAR2	N
OWNER_NAME (First Name + Last Name)	Variable	L	VARCHAR2	N
PRIMARY_YN	Variable	L	VARCHAR2	N
PROFILE_RESORT (Resort registered to the Company / Agent Profile)	Variable	L	VARCHAR2	N

COMPANY_AGENT_OWNERS File Header and Detail Data

See the Company and Agent Owners Export File Header and Detail Data

See Also

• Export Files