GROUP_IDD=Dynamic
S=Static
TL_GROUP_VW2(SQL View) |
Index Back |
|---|---|
Time Employees Group ViewTime Employees Group View |
| SELECT GROUP_ID , GROUP_TYPE_IND , DESCR , ASOFDATE , LAST_REFRESH_DTTM FROM PS_TL_GROUP_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GROUP_ID |
Character(5) | VARCHAR2(5) NOT NULL | Group ID |
| 2 | GROUP_TYPE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Type of Group: Static or Dynamic
D=Dynamic S=Static |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ASOFDATE | Date(10) | DATE | As of Date |
| 5 | LAST_REFRESH_DTTM | DateTime(26) | TIMESTAMP | Last group refresh datetime: this is only applicable to dynamic groups |