PSA_SHARING_OPT(SQL Table) |
Index Back |
|---|---|
Organizational Sharing OptionsThis record stores the sharing organization definition and processing results option. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LEVEL1_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 1 Chartfield
Default Value: PSA_ORG_DEFN.LEVEL1_CF |
| 2 | LEVEL2_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 2 Chartfield
Default Value: PSA_ORG_DEFN.LEVEL2_CF |
| 3 | LEVEL3_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 3 Chartfield
Default Value: PSA_ORG_DEFN.LEVEL3_CF |
| 4 | LEVEL4_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 4 Chartfield
Default Value: PSA_ORG_DEFN.LEVEL4_CF |
| 5 | LEVEL5_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 5 Chartfield
Default Value: PSA_ORG_DEFN.LEVEL5_CF |
| 6 | LEVEL1_CF_SW | Character(1) | VARCHAR2(1) NOT NULL |
Level 1 Chartfield Switch
Y/N Table Edit Default Value: N |
| 7 | LEVEL2_CF_SW | Character(1) | VARCHAR2(1) NOT NULL |
Level 2 Chartfield Switch
Y/N Table Edit Default Value: N |
| 8 | LEVEL3_CF_SW | Character(1) | VARCHAR2(1) NOT NULL |
Level 3 Chartfield Switch
Y/N Table Edit Default Value: N |
| 9 | LEVEL4_CF_SW | Character(1) | VARCHAR2(1) NOT NULL |
Level 4 Chartfield Switch
Y/N Table Edit Default Value: N |
| 10 | LEVEL5_CF_SW | Character(1) | VARCHAR2(1) NOT NULL |
Level 5 Chartfield Switch
Y/N Table Edit Default Value: N |
| 11 | PROCESS_RESULTS | Character(1) | VARCHAR2(1) NOT NULL |
Process Results
D=Copy original/create discount S=Create new sharing row Default Value: S |
| 12 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |