RB_TSK_CNTCT_VW(SQL View) |
Index Back |
---|---|
Task Contacts ViewTask Contacts View. Used to fix an Addut. Used by Task Management. |
SELECT TASK_ID , PERSON_ID_CNTCT , BO_ID_PERSON , BO_ID_CONTACT , ROLE_TYPE_ID_CNTCT , BO_ID_CUST , ROLE_TYPE_ID_CUST , PRIMARY_IND FROM PS_RB_TSK_CNTCT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TASK_ID | Number(15,0) | DECIMAL(15) NOT NULL | TaskIID field. Key for RB_TSK record. Used by Task Management. |
2 | PERSON_ID_CNTCT | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RD_PERSON_PN_VW |
3 | BO_ID_PERSON | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
4 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
5 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
6 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
7 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
8 | PRIMARY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No Y=Yes Y/N Table Edit Default Value: N |