BO_IDROLE_TYPE_IDPrompt Table: RB_VALID_ROLTYP
EFFDTDefault Value: %date
A=Active
I=Inactive
BO_ROLE_MSG_VW(SQL View) |
Index Back |
|---|---|
Business Object RoleBusiness Object Role defines Business Contact |
| SELECT A.BO_ID , A.ROLE_TYPE_ID , A.ROLE_START_DT , CASE WHEN A.ROLE_END_DT > %CurrentDateIn THEN 'A' ELSE 'I' END , B.DESCR , A.ROLE_START_DT , A.ROLE_END_DT , A.ROW_LASTMANT_OPRID , A.ROW_LASTMANT_DTTM FROM PS_BO_ROLE A , PS_BO_ROLE_TYPE B WHERE A.ROLE_TYPE_ID = B.ROLE_TYPE_ID AND B.PUBLISH_FLAG = 'Y' |
| # | 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 | ROLE_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL |
Role Type ID
Prompt Table: RB_VALID_ROLTYP |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | ROLE_START_DT | Date(10) | DATE | Start Date of Role |
| 7 | ROLE_END_DT | Date(10) | DATE | End Date of Role |
| 8 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 9 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |