DP_IPPOPULA_AET

(SQL Table)
Index Back

DP_IPPOPULA_AET

DP_IPPOPULA_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_POLICYCONTROL Character(20) VARCHAR2(20) NOT NULL DP_POLICYCONTROL
8 DP_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL DP_STATUS_CURRENT
1=Active
5=Pending Approval
9=Both
9 DP_INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL DP_INVENTORY_ITEM
B=Both
N=No
Y=Yes
10 DP_DELETEDATA Character(1) VARCHAR2(1) NOT NULL DP_DELETEDATA

Y/N Table Edit

Default Value: N

11 DP_SEQNUMBER Number(10,0) DECIMAL(10) NOT NULL MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.