CO_CHART_VW(SQL View) |
Index Back |
|---|
| SELECT ' ' , ' ' , 0 , ' ' , 0 FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | YEAR | Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 2 | MONTH_NAME | Character(10) | VARCHAR2(10) NOT NULL | Month Name |
| 3 | SHARES_AVAILABLE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Shares Available |
| 4 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 5 | SHARES_EXERCISABLE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Shares Exercisable |