Category Identifier: Abbreviated identifier for the user category.

Proposal Type Identifer Logical Attribute Properties

Logical Attribute Name	Proposal Type Identifer
Datatype	VARCHAR(20)
Nullable	NO

Proposal Type Identifer Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Proposal Type Identifer Security Types

Name	Current Value

Proposal Type Identifer Bound Attachments

Name	Current Value

Proposal Type Identifer Data Movement Rules

Name

Type

Rule Text/Value

Proposal Type Identifer Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Proposal Type Proposal Type Identifer	NO
EXPRESS (Oracle) PRPSL_TYPE PRPSL_TYPE_ID	NO
IPTSv5 (Oracle) PRPSL_TYPE PRPSL_TYPE_ID	NO
PRPSL (Oracle) PRPSL_TYPE PRPSL_TYPE_ID	NO
XF_ADMIN (Oracle) PRPSL_TYPE PRPSL_TYPE_ID	NO

Proposal Type Identifer Direct Source Mappings

Columns

Transformation Logic

Transformation Description

Proposal Type Identifer Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

Proposal Type Identifer Direct Target Mappings

Columns

Transformation Logic

Transformation Description

Proposal Type Identifer Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

Description: Often used in validation tables accompanying an abbreviated identifer.

Proposal Description Logical Attribute Properties

Logical Attribute Name	Proposal Description
Datatype	VARCHAR(255)
Nullable	NO

Proposal Description Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Proposal Description Security Types

Name	Current Value

Proposal Description Bound Attachments

Name	Current Value

Proposal Description Data Movement Rules

Name

Type

Rule Text/Value

Proposal Description Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Proposal Type Proposal Description	NO
EXPRESS (Oracle) PRPSL_TYPE PRPSL_TYPE_DESCR	NO
IPTSv5 (Oracle) PRPSL_TYPE PRPSL_TYPE_DESCR	NO
PRPSL (Oracle) PRPSL_TYPE PRPSL_TYPE_DESCR	NO
XF_ADMIN (Oracle) PRPSL_TYPE PRPSL_TYPE_DESCR	NO

Proposal Description Direct Source Mappings

Columns

Transformation Logic

Transformation Description

Proposal Description Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

Proposal Description Direct Target Mappings

Columns

Transformation Logic

Transformation Description

Proposal Description Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

Maximum Instrument Number Logical Attribute Properties

Logical Attribute Name	Maximum Instrument Number
Datatype	NUMERIC(1, 0)
Nullable	NO

Maximum Instrument Number Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Maximum Instrument Number Security Types

Name	Current Value

Maximum Instrument Number Bound Attachments

Name	Current Value

Maximum Instrument Number Data Movement Rules

Name

Type

Rule Text/Value

Maximum Instrument Number Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Proposal Type Maximum Instrument Number	NO
EXPRESS (Oracle) PRPSL_TYPE MAX_INSTR_NBR	NO
IPTSv5 (Oracle) PRPSL_TYPE MAX_INSTR_NBR	NO
PRPSL (Oracle) PRPSL_TYPE MAX_INSTR_NBR	NO
XF_ADMIN (Oracle) PRPSL_TYPE MAX_INSTR_NBR	NO

Maximum Instrument Number Direct Source Mappings

Columns

Transformation Logic

Transformation Description

Maximum Instrument Number Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

Maximum Instrument Number Direct Target Mappings

Columns

Transformation Logic

Transformation Description

Maximum Instrument Number Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

Auto-Close Indicator Logical Attribute Properties

Logical Attribute Name	Auto-Close Indicator
Datatype	CHAR(1)
Nullable	NO

Auto-Close Indicator Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default	'N'
Bound Default

Auto-Close Indicator Reference Value (Bound to Domain)

Name	Standard Indicator
Description	These are the standard values for the Indicator domain.
Type	By List

Value	Value Description
Y	Yes
N	No

Auto-Close Indicator Security Types

Name	Current Value

Auto-Close Indicator Bound Attachments

Name	Current Value

Auto-Close Indicator Data Movement Rules

Name

Type

Rule Text/Value

Auto-Close Indicator Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Proposal Type Auto-Close Indicator	NO
EXPRESS (Oracle) PRPSL_TYPE AUTO_CLOSE_IND	NO
IPTSv5 (Oracle) PRPSL_TYPE AUTO_CLOSE_IND	NO
PRPSL (Oracle) PRPSL_TYPE AUTO_CLOSE_IND	NO
XF_ADMIN (Oracle) PRPSL_TYPE AUTO_CLOSE_IND	NO

Auto-Close Indicator Direct Source Mappings

Columns

Transformation Logic

Transformation Description

Auto-Close Indicator Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

Auto-Close Indicator Direct Target Mappings

Columns

Transformation Logic

Transformation Description

Auto-Close Indicator Secondary Target Mappings

Columns

Transformation Logic

Transformation Description