GLRN_SETGLRN_RULEBUSINESS_UNITAS_OF_DATESEQUENCE_NBR_9ATTACHMENT_NUMA=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Awaiting Further Approvals
T=Terminated
W=Canceled
X=Suspended/Pending Denial
GLRN_AF_ATCH_VW(SQL View) |
Index Back |
|---|---|
Account Recon AttachmentsAccount Reconciliation Attachments view for Fluid Approval |
| SELECT R.GLRN_SET , R.GLRN_RULE , R.BUSINESS_UNIT , R.AS_OF_DATE , R.SEQUENCE_NBR_9 , R.ATTACHMENT_NUM , R.ATTACHSYSFILENAME , R.ATTACHUSERFILE , R.DESCR50 , R.USERID , OP.OPRDEFNDESC , R.DTTM_STAMP , AF.EOAWTHREAD_ID , AF.EOAWPRCS_ID , AF.EOAWREQUESTOR_ID , AF.EOAWTHREAD_STATUS , AF.EOAWPARENT_THREAD FROM PS_GLRN_RECON_ATTA R , PSOPRDEFN OP , PS_GLRN_AF_XREF AF WHERE OP.OPRID = R.USERID AND AF.GLRN_SET = R.GLRN_SET AND AF.GLRN_RULE = R.GLRN_RULE AND AF.BUSINESS_UNIT = R.BUSINESS_UNIT AND AF.AS_OF_DATE = R.AS_OF_DATE AND AF.SEQUENCE_NBR_9 = R.SEQUENCE_NBR_9 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GLRN_SET |
Character(20) | VARCHAR2(20) NOT NULL | Account Reconciliation Set |
| 2 | GLRN_RULE |
Character(20) | VARCHAR2(20) NOT NULL | Account Reconciliation Rule ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | AS_OF_DATE |
Date(10) | DATE | As of Date |
| 5 | SEQUENCE_NBR_9 |
Number(9,0) | DECIMAL(9) NOT NULL | Sequence |
| 6 | ATTACHMENT_NUM |
Number(5,0) | INTEGER NOT NULL | Attachment Number |
| 7 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 8 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 9 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 10 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 11 | ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered by |
| 12 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | EOAWTHREAD_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 14 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 15 | EOAWREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 16 | EOAWTHREAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Thread Status
A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Awaiting Further Approvals T=Terminated W=Canceled X=Suspended/Pending Denial |
| 17 | EOAWPARENT_THREAD | Number(15,0) | DECIMAL(15) NOT NULL | Parent Thread ID |