SYNCID1=Active
2=Approved
3=Rejected
4=Pending Approval
5=Inactive
Prompt Table:
SP_SETID_NONVW
Set Control Field: SETID
RB_TSK_PTNSC_PR(SQL View) |
Index Back |
|---|---|
Secured Partner Company PromptThis secured partner company prompt for task is used to link task to a partner. |
| SELECT A.SYNCID ,A.BO_NAME ,A.BO_NAME_UPPER ,A.PARTNER_STATUS ,A.COMPANYID ,A.SETID FROM PS_RD_PTNR_VW A , PS_SEC_SETID_OPR S WHERE A.SETID = S.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SYNCID |
Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 2 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 3 | BO_NAME_SRCH | Character(50) | VARCHAR2(50) NOT NULL | BO_NAME_SRCH |
| 4 | PARTNER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Parnter Status
1=Active 2=Approved 3=Rejected 4=Pending Approval 5=Inactive |
| 5 | COMPANYID | Character(15) | VARCHAR2(15) NOT NULL | Company ID |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table:
SP_SETID_NONVW
|