BO_IDRBW_BO_HH_VW(SQL View) |
Index Back |
|---|---|
BO Household viewView to find the Household for a particular person |
| SELECT REL.BO_ID_1 , REL.BO_ID_2 , BN.BO_NAME_DISPLAY FROM PS_RD_HOUSEHOLD HH , PS_RBW_REL_CLASS RC , PS_BO_REL REL , PS_BO_NAME_PRIM_VW BN WHERE HH.BO_ID = REL.BO_ID_2 AND RC.ROLE_TYPE_ID_ORG = REL.ROLE_TYPE_ID_2 AND HH.BO_ID = BN.BO_ID AND RC.ACTIVE_FLG = 'Y' AND RC.NEW_BO_FLG = 'Y' AND REL.START_DT <= %CurrentDateIn AND (REL.END_DT > %CurrentDateIn OR REL.END_DT IS NULL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | BO_ID_ORG | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 3 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |