APPL_FILE_ID 
Base Object  APPL_FILE 
Attribute Name  Application File Identifier 
ColumnName  APPL_FILE_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

APPL_FILE_ID Column Properties 
Datatype  NUMBER(3, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

APPL_FILE_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2 
Percent Null  0 

APPL_FILE_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

APPL_FILE_ID Security Types 
Name  Current Value 

APPL_FILE_ID Bound Attachments 
Name  Current Value 

APPL_FILE_ID Data Movement Rules 
Name  Type  Rule Text/Value 

APPL_FILE_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Application File
Application File Identifier 		 NO     
Logical
Application File
Application File Identifier 		 NO     
Logical
Application File
Application File Identifier 		 NO     
EXPRESS (Oracle)
APPL_FILE
APPL_FILE_ID 		 NO     
IPTSv5 (Oracle)
APPL_FILE
APPL_FILE_ID 		 NO     
PRPSL (Oracle)
APPL_FILE
APPL_FILE_ID 		 NO     
SMPL (Oracle)
APPL_FILE
APPL_FILE_ID 		 NO     

APPL_FILE_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

APPL_FILE_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

APPL_FILE_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

APPL_FILE_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM 
Base Object  APPL_FILE 
Attribute Name  File Name 
ColumnName  FILE_NM 
Logical Rolename   
RoleName   
Domain  File Name 
Physical Only  NO 
Definition  
File Name: An external file system file name.  Often the external file name of data imported into the Rdb, such as EPICS .db files.
 
Note 
 

FILE_NM Column Properties 
Datatype  VARCHAR2(255) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

FILE_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

FILE_NM Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

FILE_NM Security Types 
Name  Current Value 

FILE_NM Bound Attachments 
Name  Current Value 

FILE_NM Data Movement Rules 
Name  Type  Rule Text/Value 

FILE_NM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Application File
File Name 		 NO     
Logical
Application File
File Name 		 NO     
Logical
Application File
File Name 		 NO     
EXPRESS (Oracle)
APPL_FILE
FILE_NM 		 NO     
IPTSv5 (Oracle)
APPL_FILE
FILE_NM 		 NO     
PRPSL (Oracle)
APPL_FILE
FILE_NM 		 NO     
SMPL (Oracle)
APPL_FILE
FILE_NM 		 NO     

FILE_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_CONT 
Base Object  APPL_FILE 
Attribute Name  File Contents 
ColumnName  FILE_CONT 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

FILE_CONT Column Properties 
Datatype  BLOB 
Nullable  YES 
Not Null Constraint   

FILE_CONT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2048 
Percent Null  0 

FILE_CONT Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

FILE_CONT Security Types 
Name  Current Value 

FILE_CONT Bound Attachments 
Name  Current Value 

FILE_CONT Data Movement Rules 
Name  Type  Rule Text/Value 

FILE_CONT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Application File
File Contents 		 NO     
Logical
Application File
File Contents 		 NO     
Logical
Application File
File Contents 		 NO     
EXPRESS (Oracle)
APPL_FILE
FILE_CONT 		 NO     
IPTSv5 (Oracle)
APPL_FILE
FILE_CONT 		 NO     
PRPSL (Oracle)
APPL_FILE
FILE_CONT 		 NO     
SMPL (Oracle)
APPL_FILE
FILE_CONT 		 NO     

FILE_CONT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_CONT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_CONT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_CONT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_EXT 
Base Object  APPL_FILE 
Attribute Name  File Extension 
ColumnName  FILE_EXT 
Logical Rolename   
RoleName   
Domain  MIME Type 
Physical Only  NO 
Definition  
MIME Type: Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of e-mail to support:



    * text in character sets other than US-ASCII;

    * non-text attachments;

    * message bodies with multiple parts; and

    * header information in non-ASCII character sets.



MIME's use, however, has grown beyond describing the content of e-mail to describing content type in general.
 
Note 
 

FILE_EXT Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

FILE_EXT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  5 
Percent Null  0 

FILE_EXT Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

FILE_EXT Security Types 
Name  Current Value 

FILE_EXT Bound Attachments 
Name  Current Value 

FILE_EXT Data Movement Rules 
Name  Type  Rule Text/Value 

FILE_EXT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Application File
File Extension 		 NO     
Logical
Application File
File Extension 		 NO     
Logical
Application File
File Extension 		 NO     
EXPRESS (Oracle)
APPL_FILE
FILE_EXT 		 NO     
IPTSv5 (Oracle)
APPL_FILE
FILE_EXT 		 NO     
PRPSL (Oracle)
APPL_FILE
FILE_EXT 		 NO     
SMPL (Oracle)
APPL_FILE
FILE_EXT 		 NO     

FILE_EXT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_EXT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_EXT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_EXT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR 
Base Object  APPL_FILE 
Attribute Name  Description 
ColumnName  DESCR 
Logical Rolename   
RoleName   
Domain  Description 
Physical Only  NO 
Definition  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

DESCR Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

DESCR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

DESCR Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DESCR Security Types 
Name  Current Value 

DESCR Bound Attachments 
Name  Current Value 

DESCR Data Movement Rules 
Name  Type  Rule Text/Value 

DESCR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Application File
Description 		 NO     
Logical
Application File
Description 		 NO     
Logical
Application File
Description 		 NO     
EXPRESS (Oracle)
APPL_FILE
DESCR 		 NO     
IPTSv5 (Oracle)
APPL_FILE
DESCR 		 NO     
PRPSL (Oracle)
APPL_FILE
DESCR 		 NO     
SMPL (Oracle)
APPL_FILE
DESCR 		 NO     

DESCR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE 
Base Object  APPL_FILE 
Attribute Name  Current Date 
ColumnName  CUR_DTE 
Logical Rolename   
RoleName   
Domain  Date 
Physical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

CUR_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

CUR_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

CUR_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

CUR_DTE Security Types 
Name  Current Value 

CUR_DTE Bound Attachments 
Name  Current Value 

CUR_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

CUR_DTE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Application File
Current Date 		 NO     
Logical
Application File
Current Date 		 NO     
Logical
Application File
Current Date 		 NO     
EXPRESS (Oracle)
APPL_FILE
CUR_DTE 		 NO     
IPTSv5 (Oracle)
APPL_FILE
CUR_DTE 		 NO     
PRPSL (Oracle)
APPL_FILE
CUR_DTE 		 NO     
SMPL (Oracle)
APPL_FILE
CUR_DTE 		 NO     

CUR_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description