OPRIDPrompt Table: PSOPRDEFN_VW
OWNERDefault Value: AM_OWNER_TBL.OWNER
Prompt Table: AM_OWNER_TBL
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
AM_OWNER_OPR(SQL Table) |
Index Back |
|---|
| # | 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: PSOPRDEFN_VW |
| 2 | OWNER |
Character(20) | VARCHAR2(20) NOT NULL |
Asset Owner
Default Value: AM_OWNER_TBL.OWNER Prompt Table: AM_OWNER_TBL |
| 3 | RETIRE_APPROVAL_SW | Character(1) | VARCHAR2(1) NOT NULL |
Retire Approval Required
Y/N Table Edit Default Value: N |
| 4 | SHOW_COST_SW | Character(1) | VARCHAR2(1) NOT NULL |
Show Cost
Y/N Table Edit Default Value: N |