DP_DYNVIEW_AET

(SQL Table)
Index Back

DP_DYNVIEW_AET

DP_DYNVIEW_AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
3 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
4 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
5 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
6 DP_TOLEVEL Number(2,0) SMALLINT NOT NULL DP_TOLEVEL
7 DP_FROM_VIEW Character(20) VARCHAR2(20) NOT NULL DP_FROM_VIEW
8 DP_FROMLEVEL Number(3,0) SMALLINT NOT NULL DP_FROMLEVEL
9 DP_DELETEVIEW Character(1) VARCHAR2(1) NOT NULL DP_DELETEVIEW

Y/N Table Edit

Default Value: N

10 DP_DELETEDATA Character(1) VARCHAR2(1) NOT NULL DP_DELETEDATA

Y/N Table Edit

Default Value: N

11 DP_ROLLUPADJ Character(1) VARCHAR2(1) NOT NULL DP_ROLLUPADJ

Y/N Table Edit

Default Value: N

12 DP_ERRORSTATUS Number(1,0) SMALLINT NOT NULL DP_ERRORSTATUS
13 DP_PUSH_BTN2 Character(1) VARCHAR2(1) NOT NULL Other Data

Y/N Table Edit

Default Value: N

14 DP_PUSH_BTN3 Character(1) VARCHAR2(1) NOT NULL Apply

Y/N Table Edit

Default Value: N

15 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
16 DP_SUMMARIZE Character(1) VARCHAR2(1) NOT NULL Summarize the View

Y/N Table Edit

Default Value: Y