RTBL_SCE_AUL(SQL Table) |
Index Back |
---|---|
Scenario User Access |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCE_ID | Character(10) | VARCHAR2(10) NOT NULL | ID |
2 | SCE_ACCESS_USER | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID
Prompt Table: PSOPRDEFN_VW |
3 | SCE_PRIMARY_USER | Character(1) | VARCHAR2(1) NOT NULL |
Primary
N=No Y=Yes Default Value: N |
4 | SCE_AUL_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Can Process
N=No Y=Yes Default Value: N |
5 | SCE_AUL_ANALYSIS | Character(1) | VARCHAR2(1) NOT NULL |
Can Analyze
N=No Y=Yes Default Value: N |
6 | SCE_AUL_DEPLOY | Character(1) | VARCHAR2(1) NOT NULL |
Can Deploy
N=No Y=Yes Default Value: N |
7 | BU_DEFLT_FOR_ANA | Character(5) | VARCHAR2(5) NOT NULL |
Default BU for Analysis
Prompt Table: RTBL_CAF_BU_DVW |
8 | OPT_ANA_VIEW | Character(1) | VARCHAR2(1) NOT NULL |
Analysis View Option
S=Specify U=Use Default Default Value: U |
9 | CAF_SESSION_ID | Character(36) | VARCHAR2(36) NOT NULL | Session ID |