DP_RUN_CNTL_POL

(SQL Table)
Index Back

DP_RUN_CNTL_POL

DP_RUN_CNTL_POL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET

Prompt Table: DP_SI_PS1USR_VW

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 DP_TRANS_MODE Character(1) VARCHAR2(1) NOT NULL Message transaction type

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

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

Prompt Table: DP_POLCTRLS1_VW

13 DP_REBUILDLLC Character(20) VARCHAR2(20) NOT NULL DP_REBUILDLLC

Y/N Table Edit

Default Value: N

14 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name

Prompt Table: DP_PUB_FCST_VW1

15 DP_PUBLISH_DATE Date(10) DATE DP_PUBLISH_DATE

Prompt Table: DP_PUB_FCAST_VW

16 DP_ROLLFWDPERIOD Character(1) VARCHAR2(1) NOT NULL DP_ROLLFWDPERIOD

Y/N Table Edit

Default Value: N

17 DP_UPDATE_COSTS Character(1) VARCHAR2(1) NOT NULL DP_UPDATE_COSTS

Y/N Table Edit