Category Identifier: Abbreviated identifier for the user category.

PRPSL_TYPE_ID Column Properties

Datatype	VARCHAR2(20)
Nullable	NO
Not Null Constraint
Character Set	BYTE
Encrypted	NO
Encryption Algorithm	--
SALT	--

PRPSL_TYPE_ID Growth Metrics

COLUMN METRIC	COLUMN METRIC VALUE
Average Width	20
Percent Null	0

PRPSL_TYPE_ID Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

PRPSL_TYPE_ID Security Types

Name	Current Value

PRPSL_TYPE_ID Bound Attachments

Name	Current Value

PRPSL_TYPE_ID Data Movement Rules

Name

Type

Rule Text/Value

PRPSL_TYPE_ID 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

PRPSL_TYPE_ID Direct Source Mappings

Columns

Transformation Logic

Transformation Description

PRPSL_TYPE_ID Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

PRPSL_TYPE_ID Direct Target Mappings

Columns

Transformation Logic

Transformation Description

PRPSL_TYPE_ID Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

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

PRPSL_TYPE_DESCR Column Properties

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

PRPSL_TYPE_DESCR Growth Metrics

COLUMN METRIC	COLUMN METRIC VALUE
Average Width	255
Percent Null	0

PRPSL_TYPE_DESCR Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

PRPSL_TYPE_DESCR Security Types

Name	Current Value

PRPSL_TYPE_DESCR Bound Attachments

Name	Current Value

PRPSL_TYPE_DESCR Data Movement Rules

Name

Type

Rule Text/Value

PRPSL_TYPE_DESCR 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

PRPSL_TYPE_DESCR Direct Source Mappings

Columns

Transformation Logic

Transformation Description

PRPSL_TYPE_DESCR Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

PRPSL_TYPE_DESCR Direct Target Mappings

Columns

Transformation Logic

Transformation Description

PRPSL_TYPE_DESCR Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

MAX_INSTR_NBR Column Properties

Datatype	NUMBER(1, 0)
Nullable	NO
Not Null Constraint
Encrypted	NO
Encryption Algorithm	--
SALT	--

MAX_INSTR_NBR Growth Metrics

COLUMN METRIC	COLUMN METRIC VALUE
Average Width	1
Percent Null	0

MAX_INSTR_NBR Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

MAX_INSTR_NBR Security Types

Name	Current Value

MAX_INSTR_NBR Bound Attachments

Name	Current Value

MAX_INSTR_NBR Data Movement Rules

Name

Type

Rule Text/Value

MAX_INSTR_NBR 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

MAX_INSTR_NBR Direct Source Mappings

Columns

Transformation Logic

Transformation Description

MAX_INSTR_NBR Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

MAX_INSTR_NBR Direct Target Mappings

Columns

Transformation Logic

Transformation Description

MAX_INSTR_NBR Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

AUTO_CLOSE_IND Column Properties

Datatype	CHAR(1)
Nullable	NO
Not Null Constraint
Character Set	BYTE
Encrypted	NO
Encryption Algorithm	--
SALT	--

AUTO_CLOSE_IND Growth Metrics

COLUMN METRIC	COLUMN METRIC VALUE
Average Width	1
Percent Null	0

AUTO_CLOSE_IND Domain Restrictions

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

AUTO_CLOSE_IND 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_IND Security Types

Name	Current Value

AUTO_CLOSE_IND Bound Attachments

Name	Current Value

AUTO_CLOSE_IND Data Movement Rules

Name

Type

Rule Text/Value

AUTO_CLOSE_IND 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_IND Direct Source Mappings

Columns

Transformation Logic

Transformation Description

AUTO_CLOSE_IND Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

AUTO_CLOSE_IND Direct Target Mappings

Columns

Transformation Logic

Transformation Description

AUTO_CLOSE_IND Secondary Target Mappings

Columns

Transformation Logic

Transformation Description