DP_CALCPOL_AET

(SQL Table)
Index Back

DP_CALCPOL_AET

DP_CALCPOL_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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET
7 DP_TRANS_MODE Character(1) VARCHAR2(1) NOT NULL Message transaction type

Y/N Table Edit

Default Value: N

8 DP_EXPLODEDITEM Character(1) VARCHAR2(1) NOT NULL DP_EXPLODEDITEM

Y/N Table Edit

Default Value: N

9 DP_UPDATED Character(1) VARCHAR2(1) NOT NULL DP_UPDATED

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

12 DP_CREATEITEMS Character(1) VARCHAR2(1) NOT NULL DP_CREATEITEMS

Y/N Table Edit

Default Value: N

13 DP_UPDATETOINVPOL Character(1) VARCHAR2(1) NOT NULL DP_UPDATETOINVPOL

Y/N Table Edit

Default Value: Y

14 DP_POLICYCONTROL Character(20) VARCHAR2(20) NOT NULL DP_POLICYCONTROL

Prompt Table: DP_POLCTRLS1_VW

15 DP_REBUILDLLC Character(20) VARCHAR2(20) NOT NULL DP_REBUILDLLC
16 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
17 DP_PUBLISH_DATE Date(10) DATE DP_PUBLISH_DATE
18 DP_ROLLFWDPERIOD Character(1) VARCHAR2(1) NOT NULL DP_ROLLFWDPERIOD
19 DP_UPDATE_COSTS Character(1) VARCHAR2(1) NOT NULL DP_UPDATE_COSTS

Y/N Table Edit