SCC_SL_PURG_TRN(SQL Table) |
Index Back |
---|---|
Purge Run Control TransactionsThis table contains the transaction prapmeters to drive the CTM purge process. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
4 | SCC_TRANSAC_CD | Character(25) | VARCHAR2(25) NOT NULL |
Transaction
Prompt Table: SCC_TRN_SCTY_VW |
5 | SCC_TRANS_STS | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Status
BE=Submitted Error PE=Pending PO=Posted SB=Submitted SE=Saved Error SV=Saved |
6 | SCC_STG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Staging Status
AN=Add New ID CN=Cancelled LD=Loaded SA=New ID Created SI=Ignore SS=Suspended SU=ID Updated UE=Update ID VE=Error |
7 | SCC_SL_REL_CONST | Character(1) | VARCHAR2(1) NOT NULL |
Switch to include related constituent data during purge.
N=No Y=Yes Y/N Table Edit Default Value: N |
8 | SCC_SEL_OPERATOR | Character(3) | VARCHAR2(3) NOT NULL |
Allowable prompt values to determine a period time the transactions should be deleted.
<=Less Than <==Less Than or Equal To <>=Not Equal To ==Equal To >=Greater Than >==Greater Than or Equal To BTW=Date Range |
9 | SCC_AFL_DATE_FROM | Date(10) | DATE | Affiliation From Date criteria used to filter messages. |
10 | SCC_AFL_DATE_TO | Date(10) | DATE | Affiliations To Date used to filter messages |