SPF_FROM_USERTYPEREQ=Requester
SPC=Service Provider Contact
SVC=Service Coordinator
SPF_TO_USERTYPEREQ=Requester
SPC=Service Provider Contact
SVC=Service Coordinator
SPF_LAST_ACT_TYPESPF_LAST_ACT_CODESPF_NEXT_ACT_CODESPF_NX_FDRAC_VW(SQL View) |
Index Back |
|---|
| SELECT SPF_FROM_USERTYPE , SPF_TO_USERTYPE , SPF_LAST_ACT_TYPE , SPF_LAST_ACT_CODE , SPF_NEXT_ACT_TYPE , SPF_NEXT_ACT_CODE , DESCR , ACTIVITYNAME , EVENTNAME FROM PS_SPF_NX_BDACT_VW WHERE (SPF_NEXT_ACT_CODE ='0010' OR SPF_NEXT_ACT_CODE ='0001') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SPF_FROM_USERTYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Sent From user type used for determining the available bid actions
REQ=Requester SPC=Service Provider Contact SVC=Service Coordinator |
| 2 | SPF_TO_USERTYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Sent to User Type used for determining the next available bid actions
REQ=Requester SPC=Service Provider Contact SVC=Service Coordinator |
| 3 | SPF_LAST_ACT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | The last bid action type |
| 4 | SPF_LAST_ACT_CODE |
Character(4) | VARCHAR2(4) NOT NULL | the last bid action code |
| 5 | SPF_NEXT_ACT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | the next bid action type |
| 6 | SPF_NEXT_ACT_CODE |
Character(4) | VARCHAR2(4) NOT NULL | the next bid action code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 9 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |