RTBL_SCE_AUL_H

(SQL Table)
 Index Back

Scenario User Access Archive

# 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