PROC_IDDefault Value: 1
EVAL_SEQDefault Value: 25
Default Value: %date
QS_API_CTLPR_VW(SQL View) |
Index Back |
|---|---|
API Control Proc/Test viewJoin control procedures & evaluation list into one table for retrieval for API |
| SELECT PR.PROC_ID, EVAL_SEQ, 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, TEST_ID FROM PS_QS_CL_PROC PR, PS_QS_CL_EVLIST EV WHERE PR.PROC_ID = EV.PROC_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROC_ID |
Number(4,0) | SMALLINT NOT NULL |
Control Procedure
Default Value: 1 |
| 2 | EVAL_SEQ |
Number(3,0) | SMALLINT NOT NULL | Seq |
| 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
Default Value: 25 |
| 10 | QS_MOD_DATE | DateTime(26) | TIMESTAMP |
General modification date for record change tracking
Default Value: %date |
| 11 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |
| 12 | TEST_ID | Number(4,0) | SMALLINT NOT NULL | Control Test ID |