GPFR_AF_EXT_AET(SQL Table) |
Index Back |
|---|---|
Appln Framework State RecordApplication Framework - Application Framework State 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 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 5 | GPFR_AF_APPL | Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Application |
| 6 | GPFR_AF_EXTRACT_ID | Character(18) | VARCHAR2(18) NOT NULL | Application Framework - Extraction ID |
| 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 | GPFR_AF_NODE_SET | Character(16) | VARCHAR2(16) NOT NULL | Application Framework - Node Set |
| 10 | GPFR_DA_USEDDT | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
E=End Dates P=Payment Dates |
| 11 | GPFR_DUCS_GEN_FMT1 | Character(3) | VARCHAR2(3) NOT NULL |
This field indicates the period type (year, quater, month) to be processed. It is written on the GEN record. For the Urssaf Ducs, the period type is always set to 'Period' in the file. On the DUCS extraction page, the 'Period' value is not relevant.
602=Yearly Declaration 608=Quarterly Declaration 610=Monthly Declaration 900=Period Declaration |
| 12 | GPFR_AF_SNDREF | Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Sending Reference |
| 13 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
| 14 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 15 | GPFR_DA_YEAR | Number(4,0) | SMALLINT NOT NULL | DADS related field |
| 16 | GPFR_AF_NODE_NAME | Character(20) | VARCHAR2(20) NOT NULL | Application Framework - Node Name |
| 17 | GPFR_AF_KEY_NODE | Number(8,0) | INTEGER NOT NULL | Application Framework - Key Node |
| 18 | GPFR_AF_KEY_ATTR | Number(8,0) | INTEGER NOT NULL | Application Framework - Key Attribute |
| 19 | GPFR_AF_SQL_ENTITY | Character(16) | VARCHAR2(16) NOT NULL | Application Framework - SQL Entity |
| 20 | GPFR_AF_PARM_SEQ | Number(8,0) | INTEGER NOT NULL | Application Framework - PARM Sequence |
| 21 | GPFR_AF_OUTPUT_FLD | Character(18) | VARCHAR2(18) NOT NULL | Application Framework - Output Field Name |
| 22 | GPFR_AF_SRC_TYP | Character(3) | VARCHAR2(3) NOT NULL |
Application Framework - Source Type
CHR=Character DAT=Date FLD=Primary RecFldNm FLS=Sec RecFldNm NUM=Number PRM=Parameter |
| 23 | GPFR_AF_FUNCT_NM | Character(16) | VARCHAR2(16) NOT NULL | Application Framework - Function |
| 24 | GPFR_AF_PARM_NM | Character(20) | VARCHAR2(20) NOT NULL | Application Framework - Parameter |
| 25 | GPFR_AF_DON | Character(16) | VARCHAR2(16) NOT NULL | Application Framework - Data Object Name |
| 26 | GPFR_AF_SQL_SEQ | Number(8,0) | INTEGER NOT NULL | Application Framework - SQL Sequence |
| 27 | GPFR_AF_DON_SRCTYP | Character(3) | VARCHAR2(3) NOT NULL |
Application Framework - DON Source Type
CHR=Character DAT=Date FLD=Primary RecFld FLS=Secondary RecFld MAP=Mapping Code NUM=Number SQL=SQL SYS=System |
| 28 | GPFR_AF_OVRR_IND | Character(1) | VARCHAR2(1) NOT NULL |
Application Framework - Allow Override
N=No Override Y=Allow Override |
| 29 | GPFR_AF_CODE_ID | Character(12) | VARCHAR2(12) NOT NULL | Application Framework - Code ID |
| 30 | GPFR_AF_INPUT_FLD | Character(18) | VARCHAR2(18) NOT NULL | Application Framework - Input Field |
| 31 | GPFR_AF_DATE_VAL | Date(10) | DATE | Application Framework - Date |
| 32 | GPFR_AF_CHAR_VAL | Character(50) | VARCHAR2(50) NOT NULL | Application Framework - Character |
| 33 | GPFR_AF_NUM_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Application Framework - Number |
| 34 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 35 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 36 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 37 | GPFR_AF_PSAE_PRGM | Character(12) | VARCHAR2(12) NOT NULL | Application Framework - PeopleSoft AE Program |
| 38 | GPFR_AF_PSAE_SEC | Character(8) | VARCHAR2(8) NOT NULL | Application Framework - PeopleSoft AE Section |
| 39 | GPFR_AF_CUSTAE_PGM | Character(12) | VARCHAR2(12) NOT NULL | Application Framework - Customer AE Program |
| 40 | GPFR_AF_CUSTAE_SEC | Character(8) | VARCHAR2(8) NOT NULL | Application Framework - Customer AE Section |
| 41 | GPFR_AF_ATTR_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Application Framework - Attribute Status
A=Active I=Inactive |
| 42 | GPFR_AF_APPL_VER | Number(8,0) | INTEGER NOT NULL | Application Framework - Application |
| 43 | GPFR_AF_APPL_VER1 | Number(8,0) | INTEGER NOT NULL | Application Framework - Application |
| 44 | GPFR_AF_ATTR_SEQ | Number(4,0) | SMALLINT NOT NULL | Application Framework - Attribute Sequence |
| 45 | GPFR_AF_ATTR_NAME | Character(12) | VARCHAR2(12) NOT NULL | Application Framework - Attribute Name |
| 46 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 47 | GPFR_AF_FLD_TYP | Character(1) | VARCHAR2(1) NOT NULL | Application Framework - Field Type |
| 48 | GPFR_AF_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Application Framework - User Option
D=Display Only E=Edit I=Invisible |
| 49 | GPFR_AF_MANDATORY | Character(1) | VARCHAR2(1) NOT NULL | Application Framework - Mandatory |
| 50 | GPFR_AF_SIGN_IND | Character(1) | VARCHAR2(1) NOT NULL | Application Framework - Sign Indicator |
| 51 | UPDATEABLE | Character(1) | VARCHAR2(1) NOT NULL | This field was designed for EIM Roles. It specifies whether users of a given role can update information related to participants |
| 52 | GPFR_AF_PS_DON | Character(16) | VARCHAR2(16) NOT NULL | Application Framework - Peoplesoft Data Object Name |
| 53 | GPFR_AF_CUST_DON | Character(16) | VARCHAR2(16) NOT NULL | Application Framework - Customer Data Object Name |
| 54 | TIME_ELAPSED | Number(15,0) | DECIMAL(15) NOT NULL | Elapsed Time (in milliseconds) |
| 55 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 56 | GPFR_AF_COUNTER | Number(15,0) | DECIMAL(15) NOT NULL | Application Framework - Counter |
| 57 | GPFR_AF_ORDER | Number(6,0) | INTEGER NOT NULL | Application Framework - Order |
| 58 | GPFR_AF_SQL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Application Framework - SQL Type
1=Insert 2=Update 3=Delete 4=Load Parameter |
| 59 | USECOUNT | Number(3,0) | SMALLINT NOT NULL | Use Count |
| 60 | TOTAL_CNT | Number(4,0) | SMALLINT NOT NULL | Total Objects |
| 61 | GPFR_AF_OUPUT_REC | Character(20) | VARCHAR2(20) NOT NULL | Application Framework - Output Record |
| 62 | GPFR_AF_SQL_TEMPLT | Long Character | CLOB | Application Framework - SQL Template |