PROC_DESCRQS_CL_PROCS_VW(SQL View) |
Index Back |
|---|---|
Select target procs for copy |
| select proc_descr,proc_id, 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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROC_DESCR |
Character(36) | VARCHAR2(36) NOT NULL | Procedure Description |
| 2 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 3 | PROC_WINDOW_PTS | Number(3,0) | SMALLINT NOT NULL | Limits Calculate Window |
| 4 | PROC_PRELIM_PTS | Number(2,0) | SMALLINT NOT NULL | Preliminary |
| 5 | PROC_MON_PTS | Number(2,0) | SMALLINT NOT NULL | Monitoring |
| 6 | PROC_ONGOING_PTS | Number(2,0) | SMALLINT NOT NULL | OnGoing |
| 7 | PROC_RECALC_PTS | Number(3,0) | SMALLINT NOT NULL | Recalculate |
| 8 | PROC_GRAPH_PTS | Number(2,0) | SMALLINT NOT NULL | Graph Window |
| 9 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 10 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |