CDM_FILE_EXT (SQL Table)	Index Back
Rpt Dist - File types This record is used by Distribution Agent to identify additional files to be transfer to report repository and be accessible via PIA.

CDM_FILE_EXT

(SQL Table)

Rpt Dist - File types

This record is used by Distribution Agent to identify additional files to be transfer to report repository and be accessible via PIA.

Related Language Record: CDM_FILEEXT_LAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CDM_FILE_TYPE Character(10) VARCHAR2(10) NOT NULL File types to be referenced by the Distribution Agent for report distribution.

2 CDM_ADMIN Character(1) VARCHAR2(1) NOT NULL Administrator Only
Default Value: 0

3 CDM_BINARY_FILE Character(1) VARCHAR2(1) NOT NULL Transfer as Binary File
Default Value: 0

4 FLDNOTUSED Number(1,0) SMALLINT NOT NULL This field indicates whether a field is being actively used in a table or whether it is just there to avoid rebuilding the table and removing it. The default is 0, which means the field is used.
1/0 Table Edit (1=True, 0=False)
Default Value: 0

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

6 DISPLAY_OPTION Character(1) VARCHAR2(1) NOT NULL Display Option
Default Value: 1

7 CDM_TRANSFER_FILE Character(1) VARCHAR2(1) NOT NULL System file to Report Repo

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CDM_FILE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	File types to be referenced by the Distribution Agent for report distribution.
2	CDM_ADMIN	Character(1)	VARCHAR2(1) NOT NULL	Administrator Only Default Value: 0
3	CDM_BINARY_FILE	Character(1)	VARCHAR2(1) NOT NULL	Transfer as Binary File Default Value: 0
4	FLDNOTUSED	Number(1,0)	SMALLINT NOT NULL	This field indicates whether a field is being actively used in a table or whether it is just there to avoid rebuilding the table and removing it. The default is 0, which means the field is used. 1/0 Table Edit (1=True, 0=False) Default Value: 0
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	DISPLAY_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Display Option Default Value: 1
7	CDM_TRANSFER_FILE	Character(1)	VARCHAR2(1) NOT NULL	System file to Report Repo