FA_AU_COMM_RSTR(SQL View) |
Index Back |
|---|
| SELECT A.COMMON_ID ,A.INSTITUTION ,B.AID_YEAR ,A.SEQ_3C ,A.VAR_DATA_SEQ ,A.COMM_METHOD ,A.COMM_DIRECTION ,A.SCC_LETTER_CD ,A.COMPLETED_DT ,A.COMM_CONTEXT ,A.UNSUCCESSFUL ,A.OUTCOME_REASON FROM PS_COMMUNICATION A , PS_VAR_DATA_RSTR B WHERE A.COMMON_ID = B.COMMON_ID AND A.VAR_DATA_SEQ = B.VAR_DATA_SEQ AND A.ADMIN_FUNCTION = 'RSTR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 4 | SEQ_3C |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | VAR_DATA_SEQ | Number(4,0) | SMALLINT NOT NULL | Variable Data Sequence Number |
| 6 | COMM_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Communication Method
B=Publication D=Document E=Email F=Fax L=Letter P=Personal Contact T=Telephone Call W=Web |
| 7 | COMM_DIRECTION | Character(4) | VARCHAR2(4) NOT NULL |
Communication Direction
IN=Incoming Communication OUT=Outgoing Communication PERS=In Person |
| 8 | SCC_LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL | Letter Code |
| 9 | COMPLETED_DT | Date(10) | DATE | Date Activity Completed |
| 10 | COMM_CONTEXT | Character(6) | VARCHAR2(6) NOT NULL | Communication Context |
| 11 | UNSUCCESSFUL | Character(1) | VARCHAR2(1) NOT NULL |
Unsuccessful Outcome
Y/N Table Edit |
| 12 | OUTCOME_REASON | Character(1) | VARCHAR2(1) NOT NULL |
Outcome Reason
C=Missing Critical Data E=Invalid Email Address M=Left Message on Machine N=No Answer O=No Org Recipients found P=Left Message with Person R=Returned Mail S=Email Send Error |