Proposal Identifier Logical Attribute Properties

Logical Attribute Name	Proposal Identifier
Datatype	NUMERIC(10, 0)
Nullable	NO

Proposal Identifier Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Proposal Identifier Security Types

Name	Current Value

Proposal Identifier Bound Attachments

Name	Current Value

Proposal Identifier Data Movement Rules

Name

Type

Rule Text/Value

Proposal Identifier Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Program Development Proposal Review Proposal Identifier	NO
IPTSv5 (Oracle) PROG_DEV_PRPSL_REV PRPSL_ID	NO
PRPSL (Oracle) PROG_DEV_PRPSL_REV PRPSL_ID	NO

Proposal Identifier Direct Source Mappings

Columns

Transformation Logic

Transformation Description

Proposal Identifier Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

Proposal Identifier Direct Target Mappings

Columns

Transformation Logic

Transformation Description

Proposal Identifier Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

PERSON_ID Logical Attribute Properties

Logical Attribute Name	PERSON_ID
Datatype	VARCHAR(10)
Nullable	NO

PERSON_ID Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

PERSON_ID Security Types

Name	Current Value

PERSON_ID Bound Attachments

Name	Current Value

PERSON_ID Data Movement Rules

Name

Type

Rule Text/Value

PERSON_ID Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Program Development Proposal Review PERSON_ID	NO
IPTSv5 (Oracle) PROG_DEV_PRPSL_REV PERSON_ID	NO
PRPSL (Oracle) PROG_DEV_PRPSL_REV PERSON_ID	NO

PERSON_ID Direct Source Mappings

Columns

Transformation Logic

Transformation Description

PERSON_ID Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

PERSON_ID Direct Target Mappings

Columns

Transformation Logic

Transformation Description

PERSON_ID Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

Pass Fail Indicator Logical Attribute Properties

Logical Attribute Name	Pass Fail Indicator
Datatype	CHAR(1)
Nullable	NO

Pass Fail Indicator Domain Restrictions

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

Pass Fail 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

Pass Fail Indicator Security Types

Name	Current Value

Pass Fail Indicator Bound Attachments

Name	Current Value

Pass Fail Indicator Data Movement Rules

Name

Type

Rule Text/Value

Pass Fail Indicator Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Program Development Proposal Review Pass Fail Indicator	NO
IPTSv5 (Oracle) PROG_DEV_PRPSL_REV PASS_FAIL_IND	NO
PRPSL (Oracle) PROG_DEV_PRPSL_REV PASS_FAIL_IND	NO

Pass Fail Indicator Direct Source Mappings

Columns

Transformation Logic

Transformation Description

Pass Fail Indicator Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

Pass Fail Indicator Direct Target Mappings

Columns

Transformation Logic

Transformation Description

Pass Fail Indicator Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

Spokesman Comment Logical Attribute Properties

Logical Attribute Name	Spokesman Comment
Datatype	VARCHAR(2000)
Nullable	YES

Spokesman Comment Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Spokesman Comment Security Types

Name	Current Value

Spokesman Comment Bound Attachments

Name	Current Value

Spokesman Comment Data Movement Rules

Name

Type

Rule Text/Value

Spokesman Comment Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Program Development Proposal Review Spokesman Comment	NO
IPTSv5 (Oracle) PROG_DEV_PRPSL_REV SPOKE_CMNT	NO
PRPSL (Oracle) PROG_DEV_PRPSL_REV SPOKE_CMNT	NO

Spokesman Comment Direct Source Mappings

Columns

Transformation Logic

Transformation Description

Spokesman Comment Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

Spokesman Comment Direct Target Mappings

Columns

Transformation Logic

Transformation Description

Spokesman Comment Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

Program Development Review Comment Logical Attribute Properties

Logical Attribute Name	Program Development Review Comment
Datatype	VARCHAR(2000)
Nullable	YES

Program Development Review Comment Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Program Development Review Comment Security Types

Name	Current Value

Program Development Review Comment Bound Attachments

Name	Current Value

Program Development Review Comment Data Movement Rules

Name

Type

Rule Text/Value

Program Development Review Comment Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Program Development Proposal Review Program Development Review Comment	NO
IPTSv5 (Oracle) PROG_DEV_PRPSL_REV PROG_DEV_REV_CMNT	NO
PRPSL (Oracle) PROG_DEV_PRPSL_REV PROG_DEV_REV_CMNT	NO

Program Development Review Comment Direct Source Mappings

Columns

Transformation Logic

Transformation Description

Program Development Review Comment Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

Program Development Review Comment Direct Target Mappings

Columns

Transformation Logic

Transformation Description

Program Development Review Comment Secondary Target Mappings

Columns

Transformation Logic

Transformation Description