R_INT_PERSON_TYPEA=Active
I=Inactive
RA_ROLEDEFN_VW(SQL View) |
Index Back |
|---|---|
Quality Role Definition View |
| SELECT rolename , descr , descrlong , rolestatus FROM PSROLEDEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | R_INT_PERSON_TYPE |
Character(30) | VARCHAR2(30) NOT NULL | Interested Person |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRLONG | Long Character | CLOB | Long Description |
| 4 | ROLESTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Role Status
A=Active I=Inactive |