SCHEDULE_GRPDefault Value: SCH_GROUP_TBL.DESCR
Prompt Table: SETID_TBL
Prompt Table: SCH_GROUP_TBL
SCH_GROUP_VW(SQL View) |
Index Back |
|---|---|
Schedule Group Table ViewView of SChedule Group table used on SChedule Assign page to allow descriptions to be displayed for 2 Schedule Groups (Primary & Alternate) |
| SELECT SCHEDULE_GRP , DESCR , DESCRSHORT , DEFAULT_SETID , SCHEDULE_GRP_DUP FROM PS_SCH_GROUP_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCHEDULE_GRP |
Character(10) | VARCHAR2(10) NOT NULL | Scheduling Organizational Group Code |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: SCH_GROUP_TBL.DESCR |
| 4 | DEFAULT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Default Set ID
Prompt Table: SETID_TBL |
| 5 | SCHEDULE_GRP_DUP | Character(10) | VARCHAR2(10) NOT NULL |
Schedule Group ID to duplicate
Prompt Table: SCH_GROUP_TBL |