OPRIDPrompt Table: OPRID_VW
INQUIRYFIELDVALUEN=Unchecked
Y=Checked
Y/N Table Edit
Default Value: N
KK_INQ_BS_VW(SQL View) |
Index Back |
|---|---|
Inquire Budget Status VW |
| select OPRID, INQUIRY, BUDGET_STATUS, XLATSHORTNAME, CHECK_BOX_IND from PS_KK_INQ_LD_BS |
| # | 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 | INQUIRY |
Character(10) | VARCHAR2(10) NOT NULL | Inquiry Name |
| 3 | FIELDVALUE |
Character(4) | VARCHAR2(4) NOT NULL | Field Value |
| 4 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
| 5 | CHECK_BOX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Check Box Indicator
N=Unchecked Y=Checked Y/N Table Edit Default Value: N |