HRS_VENDOR_ID10=String
20=XML
HRS_JBB_VNDR_VW(SQL View) |
Index Back |
|---|
| SELECT A.HRS_VENDOR_ID , A.HRS_POSOPEN_EMBD , C.HRS_XSLT_PATH FROM PS_HRS_JBBRD_VNDR A , PS_HRS_XSLT C WHERE A.HRS_VERSION IN ( SELECT MAX(HRS_VERSION) FROM PS_HRS_JBBRD_VNDR B WHERE A.HRS_VENDOR_ID=B.HRS_VENDOR_ID) AND A.HRS_POSOPEN_XSLT=C.HRS_XSLT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_VENDOR_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Integration Vendor ID |
| 2 | HRS_POSOPEN_EMBD | Character(3) | VARCHAR2(3) NOT NULL |
Candidate Embeded State
10=String 20=XML |
| 3 | HRS_XSLT_PATH | Long Character(2000) | VARCHAR2(2000) | Path to the XSLT file |