TRN_GRPDESCR_VW(SQL View) |
Index Back |
|---|---|
Group Description ViewThis view is used in the Comments secondary panel for Group Enrollment. |
| SELECT A.GB_GROUP_ID, A.EFFDT, B.GROUP_BOOLEAN, B.GROUP_LEFT_PAREN, B.RECNAME, B.FIELDNAME, B.SQL_OPERATOR, B.GB_VALUES_LIST, B.GROUP_RIGHT_PAREN, A.COMMENTS FROM PS_GB_GROUP_TBL A, PS_GB_WHERE_TBL B WHERE A.GB_GROUP_ID = B.GB_GROUP_ID AND A.EFFDT = B.EFFDT AND A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_GB_GROUP_TBL A1 WHERE A1.GB_GROUP_ID = A.GB_GROUP_ID AND A1.EFFDT <= %CurrentDateIn ) AND B.EFFDT = (SELECT MAX(B1.EFFDT) FROM PS_GB_WHERE_TBL B1 WHERE B1.GB_GROUP_ID = B.GB_GROUP_ID AND B1.EFFDT <= %CurrentDateIn AND B1.OPERAND_SEQ = B.OPERAND_SEQ ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | GROUP_BOOLEAN | Character(3) | VARCHAR2(3) NOT NULL |
Boolean for groups
AND=AND OR=OR |
| 4 | GROUP_LEFT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Left Parentheses for groups.
0= 1=( 2=(( 3=((( 4=(((( 5=((((( |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | SQL_OPERATOR | Character(1) | VARCHAR2(1) NOT NULL |
SQL Operator
A=Equal B=Less than C=Greater than D=Less or Equal E=Greater or Equal F=In List G=Not in List H=Between I=Not Equal J=Minimum K=Maximum L=Current M=Is Null N=Not Null O=Not Between P=Like Q=Not Like R=Effdt <= S=Effdt >= T=Effdt < U=Effdt > |
| 8 | GB_VALUES_LIST | Character(254) | VARCHAR2(254) NOT NULL | Values List |
| 9 | GROUP_RIGHT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Right parentheses for group selection criteria.
0= 1=) 2=)) 3=))) 4=)))) 5=))))) |
| 10 | COMMENTS | Long Character | CLOB | Comment |