PRCS_RUNPARM(SQL Table) |
Index Back |
|---|---|
Process Run Control Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PRCSNAME |
Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 2 | PRCSTYPE |
Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 3 | SEQNO |
Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: 1 |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PT_PRCS_REC_VW |
| 5 | RECFIELDNAME | Character(34) | VARCHAR2(34) NOT NULL |
Record.Field
Prompt Table:
PT_PRCS_FLD_VW
|
| 6 | PRCS_IS_VAL_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Validation?
0=0 1=1 Y/N Table Edit Default Value: N |
| 7 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGE_VW |
| 8 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 9 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |
| 10 | PT_APPCLASSMETHOD | Character(60) | VARCHAR2(60) NOT NULL | Application Class Method Name |
| 11 | PT_PRCSLBLTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Label Type
1=Message Catalog 2=RFT Short 3=RFT Long |
| 12 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 13 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 14 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table:
PS_PRCSFLDNM_VW
|