RS_SCWB_ASGN_WS(SQL Table) |
Index Back |
|---|---|
Assignment Update Msgs Wrk ScrAssignment update messages working scroll |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | RS_ROLE_STR | Character(30) | VARCHAR2(30) NOT NULL | Role |
| 4 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 5 | LEVEL1_ROW | Number(5,0) | INTEGER NOT NULL | Level 1 Row |
| 6 | LEVEL2_ROW | Number(5,0) | INTEGER NOT NULL | Level 2 Row |
| 7 | START_DT | Date(10) | DATE | Start Date |
| 8 | END_DT | Date(10) | DATE | End Date |
| 9 | TIME_START | Time(15) | TIMESTAMP | Start Time |
| 10 | SCHEDULED_HRS | Signed Number(10,4) | DECIMAL(8,4) NOT NULL | Scheduled Hours |
| 11 | SUN | Character(1) | VARCHAR2(1) NOT NULL |
Sunday
Y/N Table Edit |
| 12 | MON | Character(1) | VARCHAR2(1) NOT NULL |
Monday
Y/N Table Edit |
| 13 | TUES | Character(1) | VARCHAR2(1) NOT NULL |
Tuesday
Y/N Table Edit |
| 14 | WED | Character(1) | VARCHAR2(1) NOT NULL |
Wednesday
Y/N Table Edit |
| 15 | THURS | Character(1) | VARCHAR2(1) NOT NULL |
Thursday
Y/N Table Edit |
| 16 | FRI | Character(1) | VARCHAR2(1) NOT NULL |
Friday
Y/N Table Edit |
| 17 | SAT | Character(1) | VARCHAR2(1) NOT NULL |
Saturday
Y/N Table Edit |
| 18 | UPDATE_ENTRY | Character(1) | VARCHAR2(1) NOT NULL |
Don't Post Duplicate Entries
Y/N Table Edit Default Value: Y |
| 19 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL |
Task Category
Prompt Table: RS_TASK_CAT |
| 20 | SKIP_INELGBL_DAYS | Character(1) | VARCHAR2(1) NOT NULL |
Skip Ineligible Days
Y/N Table Edit Default Value: INSTALLATION_RS.SKIP_INELGBL_DAYS |