OPRIDSEQ_NUMDefault Value: 1
1=(
AWD=GM_AWARD
BP=CA_BILL_PLAN
HDR=CA_CONTR_HDR
MGR=PROJECT_MGR
PRJ=PROJECT
Prompt Table: CA_MYCON_FLD_VW
1==
2=IN
3=<>
4=>
5=>=
6=<
7=<=
Default Value: 1
1=)
1=AND
2=OR
CA_MYCON_CRIT(SQL Table) |
Index Back |
|---|---|
My Contract CriteriaMy Contract Criteria |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 3 | CAMYCONCRIT_OPEN | Character(1) | VARCHAR2(1) NOT NULL |
Open Parenthesis
1=( |
| 4 | MYCON_RECNAME | Character(3) | VARCHAR2(3) NOT NULL |
Record name to be used in My Contract criteria
AWD=GM_AWARD BP=CA_BILL_PLAN HDR=CA_CONTR_HDR MGR=PROJECT_MGR PRJ=PROJECT |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: CA_MYCON_FLD_VW |
| 6 | CAMYCONCRIT_OP | Character(1) | VARCHAR2(1) NOT NULL |
Operator
1== 2=IN 3=<> 4=> 5=>= 6=< 7=<= Default Value: 1 |
| 7 | CAMYCONCRIT_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Criteria Value |
| 8 | CAMYCONCRIT_CLOSE | Character(1) | VARCHAR2(1) NOT NULL |
Close Parenthesis
1=) |
| 9 | CAMYCONCRIT_LOGIC | Character(1) | VARCHAR2(1) NOT NULL |
Logic
1=AND 2=OR |