SCC_AFL_CHRT_WK(SQL Table) |
Index Back |
|---|---|
Affiliation Chart DisplayAffiliation Chart Display |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_AFL_CODE | Character(10) | VARCHAR2(10) NOT NULL | Affiliations Code |
| 2 | START_DT | Date(10) | DATE | Start Date |
| 3 | EFFDT_TO | Date(10) | DATE | Effective Date To |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | PLAN_START_DT | Date(10) | DATE | Plan Start Date |
| 6 | PLAN_END_DT | Date(10) | DATE | Plan End Date |
| 7 | SCC_AFL_CODE_NBR | Number(5,0) | INTEGER NOT NULL | Affiliation Code Number |
| 8 | SCC_AFL_CHART_CLR | Character(2) | VARCHAR2(2) NOT NULL |
Chartbar Color
0=ChartColor_Black 1=ChartColor_Blue 10=ChartColor_Red 11=ChartColor_White 12=ChartColor_Yellow 13=ChartColor_Red_Orange 14=ChartColor_Yellow_Green 15=ChartColor_Blue_Violet 16=ChartColor_Purple 17=ChartColor_Yellow_Orange 2=ChartColor_Cyan 3=ChartColor_DarkGray 4=ChartColor_Gray 5=ChartColor_Green 6=ChartColor_LightGray 7=ChartColor_Magenta 8=ChartColor_Orange 9=ChartColor_Pink |
| 9 | SCC_AFL_DESCRSHORT | Character(50) | VARCHAR2(50) NOT NULL | Affiliations Short Description |
| 10 | SCC_AFL_URL | Character(254) | VARCHAR2(254) NOT NULL | Affiliation URL |
| 11 | SCC_AFL_TASK_LVL | Number(2,0) | SMALLINT NOT NULL | Task level |
| 12 | SCC_AFL_CH_EXPANDE | Character(1) | VARCHAR2(1) NOT NULL | Chart Parent Expanded |