ST_REPORT_SQL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier

2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

3 FROMDATE Date(10) DATE From Date

4 THRUDATE Date(10) DATE End Date

5 ST_VALUE_METHOD Character(1) VARCHAR2(1) NOT NULL Valuation Method
M=Multiple Method
S=Single Method

6 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest

7 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.

8 SQLTEXT Long Character(14000) CLOB SQL Statement Text

9 ST_PERCENT_EXER Number(7,3) DECIMAL(6,3) NOT NULL Percentage of shares granted that are exercised.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORT_ID	Character(8)	VARCHAR2(8) NOT NULL	Report Identifier
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
3	FROMDATE	Date(10)	DATE	From Date
4	THRUDATE	Date(10)	DATE	End Date
5	ST_VALUE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Valuation Method M=Multiple Method S=Single Method
6	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
7	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS.
8	SQLTEXT	Long Character(14000)	CLOB	SQL Statement Text
9	ST_PERCENT_EXER	Number(7,3)	DECIMAL(6,3) NOT NULL	Percentage of shares granted that are exercised.