POS_PERIOD_RPT

(SQL Table)
Index Back

Time Periods for Positions

This table is used strictly for the position worksheet nVision report. It stores the reporting periods for a given time span. This table is needed so that the dates are in a format agreeable to Excel and nVision.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQ_NUM_CHAR Character(3) VARCHAR2(3) NOT NULL An internal work field utilized in nVision position reporting.
2 PER_START_DT_CHAR Character(10) VARCHAR2(10) NOT NULL Represents the reporting start date for purposes of building data strings for nVision cash posit
3 PER_END_DT_CHAR Character(10) VARCHAR2(10) NOT NULL Represents the reporting end date for purposes of building data strings for nVision cash position re
4 PERIOD_START_DT Date(10) DATE Represents the date commencement point for a given time set utilized in cash worksheet processing.
5 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence