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

Application File Identifier Logical Attribute Properties 
Logical Attribute Name  Application File Identifier 
Datatype  NUMERIC(3, 0) 
Nullable  NO 

Application File Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Application File Identifier Security Types 
Name  Current Value 

Application File Identifier Bound Attachments 
Name  Current Value 

Application File Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Application File Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Application File Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Application File Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Application File Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Application File Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Name 
Base Entity  Application File 
Attribute Name  File Name 
Logical Rolename   
ColumnName  FILE_NM 
RoleName   
Domain  File Name 
Logical 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 Name Logical Attribute Properties 
Logical Attribute Name  File Name 
Datatype  VARCHAR(255) 
Nullable  NO 

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

File Name Security Types 
Name  Current Value 

File Name Bound Attachments 
Name  Current Value 

File Name Data Movement Rules 
Name  Type  Rule Text/Value 

File Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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 Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Contents 
Base Entity  Application File 
Attribute Name  File Contents 
Logical Rolename   
ColumnName  FILE_CONT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

File Contents Logical Attribute Properties 
Logical Attribute Name  File Contents 
Datatype  VARBINARY/BLOB(50) 
Nullable  YES 

File Contents Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
File Contents Security Types 
Name  Current Value 

File Contents Bound Attachments 
Name  Current Value 

File Contents Data Movement Rules 
Name  Type  Rule Text/Value 

File Contents Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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 Contents Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Contents Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Contents Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Contents Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Extension 
Base Entity  Application File 
Attribute Name  File Extension 
Logical Rolename   
ColumnName  FILE_EXT 
RoleName   
Domain  MIME Type 
Logical 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 Extension Logical Attribute Properties 
Logical Attribute Name  File Extension 
Datatype  VARCHAR(255) 
Nullable  YES 

File Extension Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

File Extension Security Types 
Name  Current Value 

File Extension Bound Attachments 
Name  Current Value 

File Extension Data Movement Rules 
Name  Type  Rule Text/Value 

File Extension Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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 Extension Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Extension Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Extension Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Extension Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

Description Logical Attribute Properties 
Logical Attribute Name  Description 
Datatype  VARCHAR(255) 
Nullable  YES 

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

Description Security Types 
Name  Current Value 

Description Bound Attachments 
Name  Current Value 

Description Data Movement Rules 
Name  Type  Rule Text/Value 

Description Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Description Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Description Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Description Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Description Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date 
Base Entity  Application File 
Attribute Name  Current Date 
Logical Rolename   
ColumnName  CUR_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Current Date Logical Attribute Properties 
Logical Attribute Name  Current Date 
Datatype  DATE 
Nullable  NO 

Current Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Current Date Security Types 
Name  Current Value 

Current Date Bound Attachments 
Name  Current Value 

Current Date Data Movement Rules 
Name  Type  Rule Text/Value 

Current Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Current Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description