HR_SCRTY_SQLHSH(SQL View) |
Index Back |
---|---|
SQL HashSQL Hash |
SELECT DISTINCT SCRTY.SCRTY_SET_CD ,SCRTY.SCRTY_TYPE_CD ,SQL.SQLID , SQL.SQLTYPE , SQL.MARKET , SQL.DBTYPE , SQL.EFFDT , SQL.HASH_SIGNATURE FROM PSSQLHASH SQL ,PS_SCRTY_TYPE_SQL SCRTY WHERE( SQL.SQLID =SCRTY.SEC_SQL_FLDNM OR SQL.SQLID=SCRTY.SEC_SQL_KEYVAL OR SQL.SQLID=SCRTY.SEC_SQL_FLDVAL OR SQL.SQLID =SCRTY.SEC_SQL_FROM OR SQL.SQLID =SCRTY.SEC_SQL_WHERE OR SQL.SQLID=SCRTY.SEC_SQL_FUT_WHERE) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCRTY_SET_CD | Character(10) | VARCHAR2(10) NOT NULL | Security Set |
2 | SCRTY_TYPE_CD | Character(3) | VARCHAR2(3) NOT NULL | Security Type for RowLevelSecurty |
3 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
4 | SQLTYPE | Character(1) | VARCHAR2(1) NOT NULL |
SQL Object type |
5 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
6 | DBTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Database Type
0=SQLBase 1=DB2 2=Oracle 3=Informix 4=DB2/UNIX 5=AllBase 6=Sybase 7=Microsoft 8=DB2/400 |
7 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
8 | HASH_SIGNATURE | Character(28) | VARCHAR2(28) NOT NULL | Hash Signature |