CUST_IDPrompt Table: FO_CUSTOMER_SR
FO_RL_CST_FB_VW(SQL View) |
Index Back |
|---|---|
Customer Feedback ViewThis View is created for Related Content Feature |
| SELECT DISTINCT A.CUST_ID , A.EMPLID , A.BUSINESS_UNIT , A.ASSIGNMENT_ID , A.SO_ID , B.DATE_OF_ENTRY , B.APPRAISER_NAME , B.DATE_SENT , B.FO_TEMPLATE_TYPE , C.DESCR254 , C.TEMPLATE_CODE , C.TEMPLATE_ITEM_CD FROM PS_FO_EMP_ASG_SRCH A , PS_FO_QUAL_FDBK_H2 B , PS_FO_CUST_QL_FDBK C , PS_FO_TEMPLATE_ITM D WHERE A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND B.FO_TEMPLATE_TYPE = C.FO_TEMPLATE_TYPE AND A.ASSIGNMENT_ID = C.ASSIGNMENT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: FO_CUSTOMER_SR |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 5 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 6 | DATE_OF_ENTRY | Date(10) | DATE | Date of Entry |
| 7 | APPRAISER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 8 | DATE_SENT | Date(10) | DATE | Date Sent |
| 9 | FO_TEMPLATE_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Form Type |
| 10 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 11 | TEMPLATE_CODE | Character(6) | VARCHAR2(6) NOT NULL | Form Code |
| 12 | TEMPLATE_ITEM_CD | Character(6) | VARCHAR2(6) NOT NULL | Form Item |