AV_ACCUM_INIT(SQL Table) |
Index Back |
|---|---|
Accumulator Init SetupProcess definition for mulitple Constituent Accumulator Initialization processes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Default Value: PRCSDEFN.PRCSTYPE Prompt Table: PRCSTYPE_VW |
|
| 2 | Character(12) | VARCHAR2(12) NOT NULL |
Process Name
Default Value: PRCSDEFN.PRCSNAME |
|
| 3 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Default Value: AV_PRCS_CONFIG.RECNAME |
| 5 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person Default Value: P |
| 6 | RANGE_FROM_01 | Character(1) | VARCHAR2(1) NOT NULL | Range From |
| 7 | RANGE_TO_01 | Character(1) | VARCHAR2(1) NOT NULL | Range To |
| 8 | AV_LOCK_GROUP | Number(3,0) | SMALLINT NOT NULL | Lock Group |
| 9 | DEFER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Defer Flag
Y/N Table Edit Default Value: N |