RUN_CNTL_SS2(SQL Table) |
Index Back |
---|---|
PS/SS Process Run Control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
4 | CTGRY_TYPE_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Category Type Select
A=Asset I=Item Default Value: I |
5 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Item SetID
Prompt Table: OPR_DEF_TBL_FS |
6 | CATEGORY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Category Type
PSF=User Def UNS=UN/SPSC Default Value: INSTALLATION_PO.CATEGORY_TYPE |
7 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL |
Category Code
Prompt Table: %EDITTABLE6 |
8 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |