PYCYCL_3_AET(SQL Table) |
Index Back |
|---|---|
Payment Selection AE Cache |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PAYSORT | Character(254) | VARCHAR2(254) NOT NULL | Pay Sort |
| 3 | PYMNT_SORT | Character(254) | VARCHAR2(254) NOT NULL | Payment Sort |
| 4 | EFT_BANK_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | EFT Bank Clause |
| 5 | SELECTPHRASE | Character(254) | VARCHAR2(254) NOT NULL | Select Phrase |
| 6 | SELECTPHRASE1 | Character(254) | VARCHAR2(254) NOT NULL | Select Phrase |
| 7 | FROMPHRASE | Character(254) | VARCHAR2(254) NOT NULL | From Phrase |
| 8 | CK_PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 9 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 10 | SIMPLE_INTR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Simple Interest Amount |
| 11 | NO_OF_MONTHS | Signed Number(4,0) | DECIMAL(3) NOT NULL | Number of Months |
| 12 | INTEREST_RATE | Number(9,5) | DECIMAL(8,5) NOT NULL | Interest Rate |
| 13 | DAYS_IN_YEAR | Number(3,0) | SMALLINT NOT NULL | Days in Year |
| 14 | COUNT_1 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 15 | TOTAL_AMT1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total Amount |
| 16 | TOTAL_AMT2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total Amount |
| 17 | LATE_CHRG_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Late Charge Amount |
| 18 | LATE_CHRG_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Late Charge Amount Base |
| 19 | LATE_CHRG_DNIE_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Late Charge Paid Base |
| 20 | LATE_CHRG_DNIE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Late Charge Denied |
| 21 | PYMNT_REASON_CD | Character(4) | VARCHAR2(4) NOT NULL | Payment Reason Code |
| 22 | SCHEDULE_ID | Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |
| 23 | NO_OF_PAYMENTS | Number(3,0) | SMALLINT NOT NULL | Payments Per Schedule |
| 24 | CUR_ROW | Number(5,0) | INTEGER NOT NULL | Current Row |
| 25 | PAY_SCHEDULE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Pay Schedule Type
MAN=Manual OTH=Other Non Transportation TRN=Transportation |
| 26 | SCHED_NBR_CHAR | Character(8) | VARCHAR2(8) NOT NULL | Schedule ID char |
| 27 | LATE_CHRG_PAID | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Late Charge Paid |
| 28 | LAST_PAY_SCHED_NBR | Number(7,0) | INTEGER NOT NULL | Last schedule ID number |
| 29 | GFAP_EFTNOOFAPPROP | Number(3,0) | SMALLINT NOT NULL | Appropriations Per Schedule |
| 30 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit |
| 31 | TRIAL_REG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
User Approval
C=Certifier Approval N=None U=User Approval |
| 32 | PYMNT_MESSAGE_CD | Character(6) | VARCHAR2(6) NOT NULL | Message Code |
| 33 | PYMNT_IMAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Payment Image ID |
| 34 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 35 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 36 | SQLID2 | Character(30) | VARCHAR2(30) NOT NULL | SQL OBJECT WORK FIELD |
| 37 | FIRST_PYMNT_ID | Number(10,0) | DECIMAL(10) NOT NULL | First Payment Id |
| 38 | FIRST_FORM_NBR | Number(10,0) | DECIMAL(10) NOT NULL | First Ref Number |
| 39 | PYMNT_ID_OLD | Character(20) | VARCHAR2(20) NOT NULL | Payment Number (Old) |
| 40 | PYMNT_ID_REF_OLD | Character(20) | VARCHAR2(20) NOT NULL | Old Payment Ref |
| 41 | PYMNT_ID_REF_LEN | Number(3,0) | SMALLINT NOT NULL | Check # Length |
| 42 | TOTAL_COUNT | Number(7,0) | INTEGER NOT NULL | Total Count |
| 43 | SELECT_WHERE | Long Character | CLOB | Select Where Clause |
| 44 | ALIAS_NAME | Character(30) | VARCHAR2(30) NOT NULL | "A user defined synonym |
| 45 | DUPLICATE_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Duplicate count |
| 46 | SUPPRESS_ZERO_CHK | Character(1) | VARCHAR2(1) NOT NULL | Suppress Zero Amount Check |
| 47 | EFT_LAYOUT_CD | Character(10) | VARCHAR2(10) NOT NULL | EFT Layout Code |
| 48 | LIMIT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Apply Restriction |
| 49 | CF_ATTRIB_VALUE | Character(20) | VARCHAR2(20) NOT NULL | ChartField Attribute Value |
| 50 | COUNT_ATTR_VAL | Number(6,0) | INTEGER NOT NULL | Attribute value count |
| 51 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 52 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 53 | COUNTER2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 2 |
| 54 | FIRST_TIME | Character(1) | VARCHAR2(1) NOT NULL | First time through process |
| 55 | SINGLE_PYMNT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Single Payment |
| 56 | IPAC_PYMNT_FLG | Character(1) | VARCHAR2(1) NOT NULL | IPAC Payment flag - will indicate that a payment is for IPAC |
| 57 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 58 | GROSS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Gross Amount |
| 59 | DUMMY_NUM | Number(6,0) | INTEGER NOT NULL | DUMMY NUM |
| 60 | TAS_BETC_PYMNT | Signed Number(5,0) | DECIMAL(4) NOT NULL | TAS/BETC Per Payment |
| 61 | TAS_BETC_SCH | Signed Number(5,0) | DECIMAL(4) NOT NULL | TAS/BETC Per Schedule |
| 62 | SPS_TAS | Character(27) | VARCHAR2(27) NOT NULL | Sender Treasury Account Symbol |
| 63 | SPS_BETC | Character(8) | VARCHAR2(8) NOT NULL | Sender Business Event Type |
| 64 | COUNTER3 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 3 |
| 65 | COUNTER4 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 4 |
| 66 | COUNTER5 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 5 |
| 67 | COUNTER6 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 6 |
| 68 | COUNTER7 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 7 |
| 69 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 70 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 71 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Remit to Location |
| 72 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 73 | GWA_REPORTER_CATG | Character(2) | VARCHAR2(2) NOT NULL |
GWA Reporter Category identifies the transactions (IPAC, TDO Payments and CASHLINK) that are being reported with the GWA standard classification. This field was added to support the Federal GWA modernization project.
00=Non Reporter 01=IPAC Only 02=AR Only 03=AP Payments Only 04=IPAC and AR 05=IPAC and AP Payments 06=AP Payments and AR 07=IPAC, AR and AP Pymts |
| 74 | FIRST_TIME_PI | Character(1) | VARCHAR2(1) NOT NULL | First Time PI |
| 75 | GFAP_EFT_ENCL_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Enclosure Code
0=Name Only 1=Direct Mail 2=Notice to Receipient 5=Foreign Mail 7=Stub |
| 76 | AP_TO_FIELD | Character(18) | VARCHAR2(18) NOT NULL | To Field |
| 77 | SAME_DAY_AMT_PYMNT | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Same Day ACH Amount Per Payment |
| 78 | PAY_DOC_ID | Character(20) | VARCHAR2(20) NOT NULL | Advice ID |