BUSINESS_UNITORIGIN_IDPrompt Table: ORIGIN_TBL
OPRIDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
SP_ORIGIN_OPRVW(SQL View) |
Index Back |
|---|---|
Origins View Operator security |
| select B.BUSINESS_UNIT, A.ORIGIN_ID, B.OPRID, A.EFFDT, A.EFF_STATUS, A.DESCR from PS_ORIGIN_TBL A, PS_SEC_ORIGIN_OPR B, PS_SET_CNTRL_REC C where B.ORIGIN_ID = A.ORIGIN_ID and B.ACCESS_CD = 'Y' and C.SETID = A.SETID and C.SETCNTRLVALUE = B.BUSINESS_UNIT and C.RECNAME = 'ORIGIN_TBL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ORIGIN_ID |
Character(5) | VARCHAR2(5) NOT NULL |
Origin ID
Prompt Table: ORIGIN_TBL |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |