IB_ARCH_RUNCNTL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).

Prompt Table: AMM_CHNL_SECVW

4 IB_ARCH_PURGEALL Character(1) VARCHAR2(1) NOT NULL Archive All Messages
A=Archive All Messages
S=Archive Specific Messages

Y/N Table Edit

5 MSGSTATUS Number(1,0) SMALLINT NOT NULL Message Status
6 IB_ARCH_MSGDATE Date(10) DATE Date
7 IB_ARCH_MSGAGE Number(3,0) SMALLINT NOT NULL Older Than
8 IB_STATUS_CANCEL Character(1) VARCHAR2(1) NOT NULL Cancel
9 IB_STATUS_DONE Character(1) VARCHAR2(1) NOT NULL Done
10 IB_ARCHIVE_SYNC Character(1) VARCHAR2(1) NOT NULL Archive Synchronous Messages

Y/N Table Edit

11 PTIB_ACTION Character(1) VARCHAR2(1) NOT NULL Actions