GPDE_BK_TRN_AET(SQL Table) |
Index Back |
---|---|
Prepare Payment Cache RecordPrepare Payment Process Cache Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
5 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
6 | STRM_NUM | Number(4,0) | SMALLINT NOT NULL | Stream Number |
7 | EMPLID_FROM | Character(11) | VARCHAR2(11) NOT NULL | EMPLID (first for a range) |
8 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | Empl ID To |
9 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
10 | ORG_LINK_OPTN | Character(2) | VARCHAR2(2) NOT NULL |
Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group
CO=Company DE=Department ET=Establishment LO=Location PG=Pay Group |
11 | RUN_CALC_IND | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Payees
Y/N Table Edit Default Value: N |
12 | RUN_FINAL_IND | Character(1) | VARCHAR2(1) NOT NULL | Finalize Entire Run |
13 | UPDATE_STATS_IND | Character(1) | VARCHAR2(1) NOT NULL | Update Statistics |
14 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
16 | GPDE_IC_CONTINUE_R | Character(1) | VARCHAR2(1) NOT NULL | Continue Program Run |
17 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
18 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
19 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL | Root Package ID |
20 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL | Qualified Package/Class Path |
21 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
22 | GPDE_CT_XMLSTRING | Long Character | CLOB | XML String |