POS_IMPCT_HDG_T

(SQL Table)
Index Back

Position Impact Headings

This table is used in the position monitor. This is a temporary table which holds the reporting periods for the position worksheet.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TIME_SET Character(10) VARCHAR2(10) NOT NULL A unique key identifier that represents a time horizon definition dataset.
2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
3 PERIOD_START_DT Date(10) DATE Represents the date commencement point for a given time set utilized in cash worksheet processing.
4 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
5 POS_IMPCT_ORIG Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the calculated monetary value for a specific position tree node; the result
6 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.