PROC_IDQS_CL_PROC_VW(SQL View) |
Index Back |
|---|---|
Control Proc prompt view |
| SELECT proc_id , proc_Version , proc_descr , proc_window_pts , proc_prelim_pts , proc_mon_pts , proc_ongoing_pts , proc_recalc_pts , proc_graph_pts , qs_mod_date , qs_mod_by FROM PS_QS_CL_PROC , ps_qs_version |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROC_ID |
Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 2 | PROC_VERSION | Number(6,0) | INTEGER NOT NULL | Proc |
| 3 | PROC_DESCR | Character(36) | VARCHAR2(36) NOT NULL | Procedure Description |
| 4 | PROC_WINDOW_PTS | Number(3,0) | SMALLINT NOT NULL | Limits Calculate Window |
| 5 | PROC_PRELIM_PTS | Number(2,0) | SMALLINT NOT NULL | Preliminary |
| 6 | PROC_MON_PTS | Number(2,0) | SMALLINT NOT NULL | Monitoring |
| 7 | PROC_ONGOING_PTS | Number(2,0) | SMALLINT NOT NULL | OnGoing |
| 8 | PROC_RECALC_PTS | Number(3,0) | SMALLINT NOT NULL | Recalculate |
| 9 | PROC_GRAPH_PTS | Number(2,0) | SMALLINT NOT NULL | Graph Window |
| 10 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 11 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |